Hi I've just created my new linux server and have yum installed various modules which all seem to be working ok now. My trouble comes from mysql. It's installed and running but when I and connect from my windows machine I get mysql error 2003.
I've read stuff about firewalls and binding ip addresses but none seem to apply or I've tried already, can anyone help.
Edit: mysqld log file says (this from a tail so seems all ready to go):
InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 130115 11:05:02 InnoDB: Started; log sequence number 0 0 130115 11:05:02 [Note] Event Scheduler: Loaded 0 events 130115 11:05:02 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.66' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
My config is here
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Which again seems ok, if there is anymore information you can need to make a suggestion please let me know.
I've got the root user up to have access from localhost and localhost.localdomain and from Any hosts as well that's mostly from the default install. There seems to be no passwords set up, and I've tried with my root password and no password.