From: Hiromichi Watari
Date: December 22 2009 5:10am
Subject: Re: MySQL running, but I cannot connect
List-Archive: http://lists.mysql.com/mysql/219872
Message-Id: <54228.43044.qm@web55903.mail.re3.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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 <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,
>=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@stripped
>=20
> =0A=0A=0A