Mysql Problems

[vassie]

Hello

I am running Red Hat 8 with Apache & mySQL, i've got a copy of PremiumSoft MySQL Studio but when I enter my details, it says it cannot connect?

My Intranet site is running fine, and mySQL is running OK, the username and password are correct but mySQL Studio says it cannot connect as "root@10.44.16.191"

Can anyone help?

Thanks

Ben :)

[tomwarren Veteran]

U sure u have it connecting to localhost?

[vassie]

It's running on my Linux server which has a fixed IP of 10.44.16.191, I left the default port as 3306, put in the username as "root" and left the password box blank as I have no password, but when I try and connect it get "Could not connect as root@10.44.16.191"

Ben :)

[vassie]

I get the same error in EMS mySQL manager too

Ben

[Steven P. Administrators]

I would still try localhost, even if just for kicks :D

[vassie]

"Could not connect as root@localhost"

:)

Ben

[brn2prgrm]

It may be a firewall/configuration error, try the following and let me know if it helps:

1) Create a custom firewall rule enabling port 3306 access by logging it as root and typing "lokkit" then restart iptables via "/etc/rc.d/init.d/iptables restart" or "/etc/rc.d/init.d/ipchains restart"

2) Modify /etc/rc.d/init.d/mysqld and replace '--skip-networking' with '--port=3306'

3) Start the daemon up via "$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --port=3306 &"

4) Log in as root to mysql (mysql -u root -p) and grant permissions to the database you want i.e. GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'serverip' identified by 'password';

5) Restart MySQL and all should be good.

Good luck!

[vassie]

I have turned the firewall off completley

Its on our corporate network, so i thought it wasn't needed

Ben

[brn2prgrm]

  bennyboyamo said:

I have turned the firewall off completley

Its on our corporate network, so i thought it wasn't needed

Ben

Hmm, well did steps 2-5 help at all?

[vassie]

I'll give 'em a go

Ben

[zivan56]

Make sure in your my.cnf that:

skip-networking

Is not present in the file.

[brn2prgrm]

Any luck? ::keeps fingers crossed::

[Tim Dorr Veteran]

you probably need to give root login rights from your IP.

Try step 4 above or looking in the MySQL docs on how to do this :)