Terry, > I 've a problem with permission setup. In my newly install MySQL > server; First, I log into as 'root' and create a database, lets say 'myDB'. > Then I Grant a user name 'admin' with password to that database'myDB' in > hostname 'network.srv'. Then I log out from root account.
Let's suppose your GRANT statement was okay. Better if you would provide the statement you issued. > I tried to log in as 'admin' using password to the same host. > %mysql -u admin -network.srv -p > password:****** That should be "mysql -u admin -h network.srv -p". Let's assume you specified that. > In this point the server said "Access Denied to user [EMAIL PROTECTED], > blablabla". That "blablabla" might hold some information worth posting. > Is there any mistake in my job? I'm using W2K server as OS. When asking a question like that, you should provide information like the following sessions info: mysql> STATUS; -------------- mysql Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32) Connection id: 7 Current database: GuideProf Current user: [EMAIL PROTECTED] SSL: Not in use Server version: 4.0.10-gamma-max-nt-log Protocol version: 10 Connection: localhost via TCP/IP Client characterset: latin1_de Server characterset: latin1_de TCP port: 3306 Uptime: 1 day 1 hour 18 min 47 sec Threads: 1 Questions: 226 Slow queries: 10 Opens: 102 Flush tables: 1 Open table -------------- mysql> GRANT ALL ON test.* TO 'someoneelse'@'localhost' IDENTIFIED BY 'youwontguess'; Query OK, 0 rows affected (0.19 sec) mysql> EXIT Bye C:\mysql\bin>mysql -h localhost -u someoneelse -pyouwontguess Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 to server version: 4.0.10-gamma-max-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> USE mysql; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' mysql> USE test; Database changed Look at the last couple of lines. They show that the privileges were granted as expected. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
