Topic: MySQL_GUI

[Ralph]

I’m using SME Server V5 and it’s been terrific!. Keep up the great work.. However, I have a question regarding MySQLGUI.exe 1.7.5-2 attaching from a Win98 machine on my local network. I’m either overlooking something or did not set something up right. Here’s what I did:

 I GRANTED full access rights and privileges using the mysql monitor, and I read back the mysql>user table to prove that the password and host were entered.

I'm using socket /var/lib/mysql/mysql.sock, and port 3306 and checked it with mysqladmin. I forwarded port 3306 on my hardware router.

I can also access the mysql monitor over ssh if that means anything.  However, the MySQLGUI on Win98 will not attach, it prompts for the password, I enter it, it hangs for a few seconds, then it says Access denied for user: 'ralph@pc-00100' (Using password: YES).

(Please post to the forum so others can also benefit, as I have read all the past postings and there is no mention if anyone has been able to get it working.)

Thanks,

Ralph

[Johan]

Ralph:

You must first make a account what also can work from a ather machienne then your server.

You can do that whith the folow command liner:

Log in whit root on the console (are whith ssh)

shell > mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
           IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
           IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

the first row makes a new user "monty" to do everything on the server and the second row makes that the user "monty" can acces the database from every ather computer

I have this from the site off mysql.com from the follow link: http://www.mysql.com/doc/A/d/Adding_users.html

You can always read it futher

Grtz

From Amsterdam

Johan

[Ralph]

It worked!!... thanks. I was replacing the localhost hostname with my remote server hostname. I did not realize it wanted localhost. All works fine now. Thanks again.