Hey guys, i have MySQL on my CentOS server and have installed it and got it up and running through the command line.

I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.

Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'

When i try to log in it gives me error 1130 and says connection from myhostname not allowed.

Any ideas?

Cheers.

(i am a mysql newb).

Hi,

Did you change the setting in my.cnf to make MySQL listen on the IP of your server? Default it only listens on localhost.

Kind regards,

Eric

this is all i have in my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Hi,

Just below the mysqld section in the my.cnf file add this:
and restart MySQL to apply the changes. Then you should be able to connect, if no firewall or SELinux is enabled. If those are enabled you'll also have to make sure that connections to the MySQL server are allowed.

Kind regards,

Eric

1 members found this post helpful.

cheers!

Hello,

If that means you got it working then please mark your thread as solved using the Thread tools. Have fun using Linux.

Kind regards,

Eric

Sorry, too late You already did it.