Results 1 to 3 of 3
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 12-10-2003 #1
- Join Date
- Aug 2003
Accessing MySQL (Running on RH9) via MySQL control centre
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: 'email@example.com' (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.
- 12-10-2003 #2
You could use the cmd based client if you have shell access or do you need to get this running?
- 12-10-2003 #3
- Join Date
- Apr 2003
- London, UK
Mysql (at least v4+) IIRC 3.23x controls access based on 3 items:
3) Hostname/IP address.
By Default, the root user (with or without password) can only connect from localhost by default. Dont use the root user to connect remotely.
Create a new user/pass specifically for what you need to do..
ssh to your box, run:
user@localhost# mysql -h localhost -u root -ppassword mysql> GRANT ALL PRIVILEGES ON *.* TO <USERNAME>@192.168.2.15 IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
For safety purposes, if this user only needs to access one database, and is a "proper" user, this might be more appropriate:
user@localhost# mysql -h localhost -u root -ppassword mysql> GRANT ALL PRIVILEGES ON <DATABASE>.* TO <USERNAME>@192.168.2.15 IDENTIFIED BY 'some_pass';
See also: http://www.mysql.com/doc/en/Adding_users.html