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 6 129839
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
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
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
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
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;
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; This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: |
last post by:
I issued the mysql command
Grant all on *.* to myid@localhost identified as "mypw";
and recieved the error message
ERROR 1045: Access denied for user" '@localhost' (Using password: NO)
I...
|
by: Marc |
last post by:
Hello,
I have 3 users in my MySQL server. One of them has Grant access
(actually: all privileges). I cannot login as this user using
phpMyAdmin - my password is not accepted (though I' m sure it...
|
by: Charles Cantrell |
last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of
Mandrake, I believe), using the binary 4.0.13 standard release.
The set up and start up all were normal, as far as I...
|
by: Charles Cantrell |
last post by:
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of
Mandrake, I believe), using the binary 4.0.13 standard release.
The set up and start up all were normal, as far as I...
|
by: Marc |
last post by:
Hello,
I have 3 users in my MySQL server. One of them has Grant access
(actually: all privileges). I cannot login as this user using
phpMyAdmin - my password is not accepted (though I' m sure it...
|
by: binary-nomad |
last post by:
How do I make a table with fields again, say, name, age, address, wife
etc. that I want people to be able to look at (with any client like
MysqlCC etc), but only be able to modify certain fields,...
|
by: tabai |
last post by:
Hi.
I'm trying the database privileges, I create diferent users in my
database server. Use A and user B in two diferents groups (GA and GB),
I create a database (DBA) with user A, and grant...
|
by: Oracle10 |
last post by:
Hi all,
I have created a user and I want that all the privileges(select,update,insert,delete etc) should be automatically granted to this newly created user.Please anybody can tell me...
|
by: mehtab |
last post by:
How to grant privileges to a mysql user by using php.
If any one have knowledge about the privileges then please help me!
Thank
Best regard
|
by: nomad |
last post by:
Hello Everyone.
I need some help in create Privileges for a new db.
I'm using a host call addr.com and I hate them for there cpanel sucks.
any I hav to write a MySQL to Grant All Privileges for a...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |