Accessing a Linux MYSQL server from Windows via MySQL control centre 2

[tekquest]

Hi all,

I have spent just about all day trying to connect a windows 2000 pc via Mysql control centre to my Redhat linux 9.0 box, running mysql.

I can view the tables from the linux boxes command shell, I have set a temp password "password".

When I try to access the mysql database / server from windows via the mysql control centre, it returns a message "[mysqlcctmp_1] ERROR 1045: Access denied for user: 'root@192.168.2.15' (using password: YES).

I am using the root account + its admin password (the same username / password that I use to access Mysql in the command shell on the linux box.

I have read about granting permissions to the root password on other domains than localhost, I have done alot of searching around the net and I cant seem to find anything relivant.

Its MySQL v. 3.23.54 running on the RH9.0 linux box, the MySQL control centre is v.0.9.3-beta running on my windows 2000 machine.

The linux box has no firewall and I can access shares on it via samba and copy files etc.

Any input would be appreciated.

Thanks for reading.

 

[sleipnir214]

It's probably a permission problem

MySQL user credentials are a 3-tuple of username, password, and IP address of connecting client. It's possible, for example, for a user to be able to connect from localhost but not from other IP addresses.

Check the "host" column of the "user" table in the "mysql" database on your server to see from where your root user is allowed to connect. If that value doesn't allow connections from your client machine, you need to modify the host column or create another user which can connect from your client.

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[tekquest]

Thanks for the input, much appreciated.

I have done further searching for granting permissions to the sql tables, can I add these to the included db "mysql" ? or do I need to add a new db?

How do I modifiy permissions on the databases / check the colums?? I know its via the Terminal, I read this document:

http://smb.slac.stanford.edu/blu-ice/dcsAdmin-1_11/node27.html

and changed the db from "beamlines" to "mysql", still no go.

 

[sleipnir214]

MySQL installs with the permissions database, "mysql". All records pertaining to user permissions must go there.

You can either directly manipulate the mysql database, or you can use the GRANT command.

http://www.mysql.com/doc/en/Adding_users.html

http://www.mysql.com/doc/en/GRANT.html

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[tekquest]

I see, interesting.

So if I wanted to access the mysql database with the root username / password remotely (e.g. from another pc, running windows), I would use:

GRANT ALL ON *.* TO ROOT@'%';

?

 

[sleipnir214]

You're pretty close.

I would use a username other than root, I would require that that user provide a password, and I would limit the addresses from which the user could connect to my own network:

GRANT ALL ON *.* to foo@'10.1.1.%' IDENTIFIED BY 'bar'

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[tekquest]

Got it!!! LOGGED IN!!

Thank you so much, I am so impressed! :-D

I can see the databases and their table information! :-D :-D

I feel like this right now... "it happened on one of those zip-a-dee-doo-dah days..." LOL.

Thanks again sleipnir214, your assistance is much appreciated!.

 

[syntec]

I have tried to follow what has been posted... But I'm trying to make a PC on my home network be able to access a MYSQL database on our server. I'm also using Webmin in Linux to set up permissions. I tried setting "User Permissions" but I still unable to access the database. I'm far from an expert in this and I would appreciate any help on this.

 

[sleipnir214]

Is the server on your home network?

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[syntec]

Yes

 

[sleipnir214]

I've never used the Webmin scripts for managing MySQL. I generally use some special-purpose GUI app.

The query to execute on your server to allow a user "foo" with the password "bar" to access all tables in the database "thedat" from your home newtork is:

GRANT ALL ON thedat.* TO foo@'192.168.%' IDENTIFIED BY 'bar'

Want the best answers? Ask the best questions:

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

TANSTAAFL!!