By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,017 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,017 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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.