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 <mailingli...@mailnewsrss.com> wrote:
> From: ML <mailingli...@mailnewsrss.com>
> Subject: MySQL running, but I cannot connect
> To: mysql@lists.mysql.com
> 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=hiromichiwat...@yahoo.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
