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_db which is the command to
create these, I get the following excerpt:

linux:/usr/bin # mysql_install_db --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]

Brett B wrote:

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_db which is the command to
create these, I get the following excerpt:

linux:/usr/bin # mysql_install_db --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
....

just create my.cnf in /etc/

#vi /etc/my.cnf

and paste following things

[mysqld]
thread_stack=128K

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

-- Azuu

[vetolimits]

just create /etc/my.cnf

# vi /etc/my.cnf

then paste following things

[mysqld]
thread_stack=128K

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

Azhu

[Bill Karwin]

Brett B wrote:

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.

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]

Thanks, Works like a charm!

ve********@yahoo.com wrote in message news:<11**********************@o13g2000cwo.googleg roups.com>...

just create /etc/my.cnf

# vi /etc/my.cnf

then paste following things

[mysqld]
thread_stack=128K

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

Azhu