MySQL running, but I cannot connect

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.=20

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.=20

I tried stopping mysql with /etc/init.d/mysqld stop

Then starting with mysqld_safe --init-file=3D/tmp/code.txt &

Where code.txt contains:

UPDATE mysql.user SET Password=3DPASSWORD('BabyToad09') WHERE =
User=3D'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.=20

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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: MySQL running, but I cannot connect

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 execut=
able 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=3D192.168.2.3
run a client session as the root, directory your execut=
able resides might be different than what's shown, also replace the IP addr=
ess with that of your MySQL server host machine.

Good luck !
Hiromichi




--- On Mon, 12/21/09, ML wrote:

> From: ML
> Subject: MySQL running, but I cannot connect
> To: mysql@lists.mysql.com
> Date: Monday, December 21, 2009, 8:35 PM
> Hi All,
>=20
> MySQL 5.0.77 on CentOS 5.4
>=20
> MySQL is running, my Wordpress stuff is working, but I
> cannot connect to the server from my house.=20
>=20
> I checked the firewall and that is successfully allowing
> the passage.
>=20
> I checked the firewall on the server and that has 3306:tcp
> allowed.
>=20
> 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.
>=20
> If I look in /var/log/mysqld.log I dont see anything but
> the fact the server started.=20
>=20
> I tried stopping mysql with /etc/init.d/mysqld stop
>=20
> Then starting with mysqld_safe --init-file=3D/tmp/code.txt
> &
>=20
> Where code.txt contains:
>=20
> UPDATE mysql.user SET Password=3DPASSWORD('BabyToad09') WHERE
> User=3D'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;
>=20
> and I still cannot connect.=20
>=20
> What am I doing wrong? What can I check for? Things work,
> just not for me from home.
>=20
> -Jason
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Dhiromichiwata=
ri@yahoo.com
>=20
> =0A


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg