Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: Ralph on December 25, 2001, 09:10:58 AM
-
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
-
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
-
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.