MySQL Newbie install question
Hi I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box. When I try to contact the mysql server i get the following error: [someone@somemachine ~]$ mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! /var/lib/mysql/mysql.sock exists. My syslog doesnt log anything from MySql. Port 3306 is free and the DB answers when I telnet to the port but reports the error below: IHost 'somehost.com' is not allowed to connect to this MySQL serverConnection closed by foreign host. I am using tcpwrappers but local host (and somehost.com) has been added to hosts.allow. Any and all ideas as to what I am doing wrong or missing greatly appreciated! Thanks, Damian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Newbie install question
Hi I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box. When I try to contact the mysql server i get the following error: [someone@somemachine ~]$ mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! /var/lib/mysql/mysql.sock exists. My syslog doesnt log anything from MySql. Port 3306 is free and the DB answers when I telnet to the port but reports the error below: IHost 'somehost.com' is not allowed to connect to this MySQL serverConnection closed by foreign host. I am using tcpwrappers but local host (and somehost.com) has been added to hosts.allow. Any and all ideas as to what I am doing wrong or missing greatly appreciated! Thanks, Damian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Newbie install question
TCPwrappers has nothing to do with mysql. Mysqld manages the port itself. You do not want tcpwrappers grabbing the port. Check the path to mysql.sock. It must be world searchable and readable for the client to write to the socket. Read the section of the manual on GRANT privileges. You are not root. Unless you specify -u root, you can't do anything. There are no users that can access the server until you set them up. Damian Moran wrote: Hi I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box. When I try to contact the mysql server i get the following error: [someone@somemachine ~]$ mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! /var/lib/mysql/mysql.sock exists. My syslog doesnt log anything from MySql. Port 3306 is free and the DB answers when I telnet to the port but reports the error below: IHost 'somehost.com' is not allowed to connect to this MySQL serverConnection closed by foreign host. I am using tcpwrappers but local host (and somehost.com) has been added to hosts.allow. Any and all ideas as to what I am doing wrong or missing greatly appreciated! Thanks, Damian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php