List:General Discussion« Previous MessageNext Message »
From:Hiromichi Watari Date:December 22 2009 5:10am
Subject:Re: MySQL running, but I cannot connect
View as plain text  
Hi Jason,
Here is what I did to connect:

1) start a client session on server host machine and issue a grant command.

/usr/local/mysql$ bin/mysql -u root
                    run a client session as the root, directory your executable resides
might be different than what's shown

mysql> use mysql ;
mysql> grant all on mydatabase.* to root ;
                    replace mydatabase with yours

2) start a client session from a remote host.

/usr/local/mysql$ bin/mysql -u root --host=192.168.2.3
                    run a client session as the root, directory your executable resides
might be different than what's shown, also replace the IP address with that of your MySQL
server host machine.

Good luck !
Hiromichi




--- On Mon, 12/21/09, ML <mailinglists@stripped> wrote:

> From: ML <mailinglists@stripped>
> Subject: MySQL running, but I cannot connect
> To: mysql@stripped
> Date: Monday, December 21, 2009, 8:35 PM
> Hi All,
> 
> MySQL 5.0.77 on CentOS 5.4
> 
> MySQL is running, my Wordpress stuff is working, but I
> cannot connect to the server from my house. 
> 
> I checked the firewall and that is successfully allowing
> the passage.
> 
> I checked the firewall on the server and that has 3306:tcp
> allowed.
> 
> When I try to connect I get an error (4) which when I
> google says: "Interrupted System call"
> I have tried using the MySQL Workbench and other client
> software.
> 
> If I look in /var/log/mysqld.log I dont see anything but
> the fact the server started. 
> 
> I tried stopping mysql with /etc/init.d/mysqld stop
> 
> Then starting with mysqld_safe --init-file=/tmp/code.txt
> &
> 
> Where code.txt contains:
> 
> UPDATE mysql.user SET Password=PASSWORD('BabyToad09') WHERE
> User='root';
> GRANT ALL ON mysql.* to 'root'@'127.0.0.1';
> GRANT ALL ON mysql.* TO 'root'@'localhost';
> GRANT ALL ON mysql.* TO 'root'@'my home IP';
> FLUSH PRIVILEGES;
> commit;
> 
> and I still cannot connect. 
> 
> What am I doing wrong? What can I check for? Things work,
> just not for me from home.
> 
> -Jason
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


      

Thread
MySQL running, but I cannot connectML22 Dec
  • Re: MySQL running, but I cannot connectHiromichi Watari22 Dec