Can't create the system/user mySQL Tables

[Brett B]

Folk,

I have mysql installed via rpm package, but when I check the data
dirs, the only table there is "test". The instructions say there
should be others, like users tables, and other such tables.

I stopped the server and ran mysql_install_d b which is the command to
create these, I get the following excerpt:

linux:/usr/bin # mysql_install_d b --user=mysql
Installing all prepared tables
050304 6:10:00 [Warning] Asked for 196608 thread stack, but got
126976
Fill help tables
050304 6:10:00 [Warning] Asked for 196608 thread stack, but got
126976
.....

But when I check, it doesn't seem to make these tables, only the test
table.

Is this normal? I thought the user table contains the login info, so
if there isn't one, how can I log in?

Thanks,
Brett

[vetolimits@yahoo.com]

Re: Can't create the system/user mySQL Tables

Brett B wrote:[color=blue]
> Folk,
>
> I have mysql installed via rpm package, but when I check the data
> dirs, the only table there is "test". The instructions say there
> should be others, like users tables, and other such tables.
>
> I stopped the server and ran mysql_install_d b which is the command to
> create these, I get the following excerpt:
>
> linux:/usr/bin # mysql_install_d b --user=mysql
> Installing all prepared tables
> 050304 6:10:00 [Warning] Asked for 196608 thread stack, but got
> 126976
> Fill help tables
> 050304 6:10:00 [Warning] Asked for 196608 thread stack, but got
> 126976
> ....[/color]

just create my.cnf in /etc/

#vi /etc/my.cnf

and paste following things

[mysqld]
thread_stack=12 8K

now save file... restart mysql -- see the logs -- i hope it works..

-- Azuu

[vetolimits@yahoo.com]

Re: Can't create the system/user mySQL Tables

just create /etc/my.cnf

# vi /etc/my.cnf

then paste following things

[mysqld]
thread_stack=12 8K

save the file and restart mysql -- see the logs hope this works.

Azhu

[Bill Karwin]

Re: Can't create the system/user mySQL Tables

Brett B wrote:[color=blue]
> Folk,
>
> I have mysql installed via rpm package, but when I check the data
> dirs, the only table there is "test". The instructions say there
> should be others, like users tables, and other such tables.[/color]

Just a hunch here...

If you log in to MySQL anonymously, that is without specifying a
username, you may have privileges only to certain databases, e.g. the
'test' database.

Try: mysqlshow -u root

That should show the list of databases that the MySQL superuser account
has privilege to see.

Regards,
Bill K.

[Brett B]

Re: Can't create the system/user mySQL Tables

Thanks, Works like a charm!

vetolimits@yaho o.com wrote in message news:<110995178 7.804981.135230 @o13g2000cwo.go oglegroups.com> ...[color=blue]
> just create /etc/my.cnf
>
> # vi /etc/my.cnf
>
> then paste following things
>
> [mysqld]
> thread_stack=12 8K
>
> save the file and restart mysql -- see the logs hope this works.
>
> Azhu[/color]