468,740 Members | 2,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,740 developers. It's quick & easy.

Can't create the system/user mySQL Tables

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
Jul 23 '05 #1
4 1258
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

Jul 23 '05 #2
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

Jul 23 '05 #3
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.
Jul 23 '05 #4
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

Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Fred Johnson | last post: by
2 posts views Thread by picaza | last post: by
2 posts views Thread by pc | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.