add % line to your grants.
that means this user can connect from everywhere.
read mysql documents Section 6.13 for detail instructions.
shell> mysql --user=root mysql
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql> INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
mysql> INSERT INTO user SET Host='localhost',User='admin',
Reload_priv='Y', Process_priv='Y';
mysql> INSERT INTO user (Host,User,Password)
VALUES('localhost','dummy','');
mysql> FLUSH PRIVILEGES;
----- Original Message -----
From: johnd <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 25, 1999 10:23 PM
Subject: How to config the client installation
Hi,
I installed the Win32 static binary of MySQL GUI 1.7.4-2. client version on
one computer.
I have also MySQL 3.23.37 mysqld-nt server installed on another computer. I
can ping each other.
I tried to connect from client to server, but failed. Error shows: Access
denied for user: 'administrator@JOHND' (Using password: YES)
Here is server side my.ini file:
#This File was made using the WinMySQLadmin 1.1 Tool
#4/24/2001 12:04:36 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=D:\MySQL
#bind-address=208.199.176.191
datadir=D:\MySQL\data
#language=D:\MySQL\share\your language directory
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=D:/MySQL/bin/mysqld-nt.exe # I tried to replace the "/" instead
of "\", it can't do it.
user=administrator@johnd # This is the computer that
client software installed.
password=password
Could you tell me how to configue these on both side to get connect?
Thank you very much.
Regards,
John Ding
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
