469,291 Members | 1,786 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,291 developers. It's quick & easy.

GRANT ALL PRIVILEGES ON db.* .....

mysql Ver 3.23.54

Having read, as best I could, the docs at http://www.mysql.com/documentation ...,

on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter:

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max
Jul 19 '05 #1
6 129457
BDR
Stop, and Restart MySQL

maxwell wrote:
mysql Ver 3.23.54

Having read, as best I could, the docs at http://www.mysql.com/documentation ...,

on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter:

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max


Jul 19 '05 #2
BDR
Stop, and Restart MySQL

maxwell wrote:
mysql Ver 3.23.54

Having read, as best I could, the docs at http://www.mysql.com/documentation ...,

on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter:

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max


Jul 19 '05 #3
BDR <jo*@noemail.com> wrote in message news:<iO*****************@bignews4.bellsouth.net>. ..
Stop, and Restart MySQL

maxwell wrote:
mysql Ver 3.23.54

Having read, as best I could, the docs at http://www.mysql.com/documentation ...,

on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter:

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max


If you can restart the server, go ahead and your GRANT will be
effected. Otherwise, a FLUSH PRIVILEGES will do the job. Please check
the FLUSH syntax for options.

regards
akr
Jul 19 '05 #4
BDR <jo*@noemail.com> wrote in message news:<iO*****************@bignews4.bellsouth.net>. ..
Stop, and Restart MySQL

maxwell wrote:
mysql Ver 3.23.54

Having read, as best I could, the docs at http://www.mysql.com/documentation ...,

on host (Linux from scratch, kernel 2.4.20) "mysql.here.com" I enter:

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max


If you can restart the server, go ahead and your GRANT will be
effected. Otherwise, a FLUSH PRIVILEGES will do the job. Please check
the FLUSH syntax for options.

regards
akr
Jul 19 '05 #5
In article <28*************************@posting.google.com> , maxborn555
@yahoo.com says...
mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max


Shouldn't that have been?

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com' IDENTIFIED BY
'mypass';

It's either missing a password or you needed to do FLUSH PRIVILEGES;
Jul 19 '05 #6
In article <28*************************@posting.google.com> , maxborn555
@yahoo.com says...
mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com';
Query OK, 0 rows affected (0.00 sec)

but ...

[ro**@max.here.com]# mysql -h mysql.here.com -u root -pmypass
ERROR 1045: Access denied for user: 'ro**@max.here.com' (Using password: YES)

"netstat -lt" on mysql.here.com shows the socket is listening okay.

tcp 0 0 *:mysql *:* LISTEN

Any ideas?

Max


Shouldn't that have been?

mysql> GRANT ALL PRIVILEGES ON db.* TO root@'max.here.com' IDENTIFIED BY
'mypass';

It's either missing a password or you needed to do FLUSH PRIVILEGES;
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by | last post: by
3 posts views Thread by Marc | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Marc | last post: by
8 posts views Thread by binary-nomad | last post: by
1 post views Thread by tabai | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.