creating new users

[Noip]

Hi,

I am a newbie to MySQL and I have just setup a Linux box and start the mysql daemon. I have tried to create a user 'dbuser' with a password 'xxxxx' using the following:

shell> mysql --user=root mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO dbuser@localhost
-> IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO dbuser@"%"
-> IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;

I have not created any database yet. I want to connect from another PC on the same LAN using MySQL front to the table 'test'. The error on the MySQL front PC is:

MySQL Error
Connection failed:
2013 - Lost connection to MySQL server during query

I have not altered anything on the MySQL server except the above mentioned.
I have no firewall set between!
Please help!
ALso is the password being created for the user: xxxxx or 'xxxxx'?

Thanks for any advice!

 

[sleipnir214]

Are you running MySQL on Redhat 8 and accessing the database server from another machine?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Noip]

Yes,
The linux box is RH8.0 and the client PC is win98

 

[sleipnir214]

There is a known bug in a library that ships with RH8.0 and that MySQL uses for communication with foreign clients.

Take a look at this thread: thread436-520613

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Noip]

thanks,

but how can i check on the server whether it likes the user just created

 

[sleipnir214]

You haven't gotten that far in the process, yet. You have to connect to the server before you can perform any actions, and this bug is keeping you from connecting.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!