On 6/22/05, it clown <suse@mailbox.co.za> wrote:
Hi All,
How do you allow mysql administrator ( windows versoin ) to connect to mysql running on suse 9.1?
I read that you must create a user that can connect from any host. How do you create such a user?
Thanks Regards _____________________________________________________________________ For super low premiums, click here http://www.dialdirect.co.za/quote
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
smells like a long rtfm session.. ;) have a look at /usr/share/doc/packages/mysql/manual.txt but to provide a quickstart: 1. first off all, login to the linux box. 2. be shure mysql is started.. (check with "rcmysql status", if not running "rcmysql start") 3.. set a root password (this is the mysql admin user.. not the linux root user), which is empty from the beginning, for mysql with: #> /usr/bin/mysqladmin -u root password 'new-password' 4. now, you must allow external connections for this mysql-root user for your PC with mysql-administrator.. (still on your linux box) start the mysql client and enter the newly set password when prompted.. and grant access for mysql-user root@your-mysqladministrator-PCs-ip-addess #> mysql -h localhost -u root --password Enter password: mysql> GRANT ALL PRIVILEGES ON *.* TO root@192.168.1.13 IDENTIFIED BY 'mysql-root-users-password' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql>quit bye remember, use your ip-address and mysql-root users password you'd like to use here! this was just an example.. and you're done. now connect from your mysql administrator as mysql-user "root" with the password you have setfor root@ipaddress during your GRANT command. hope that helps.. markus