473,322 Members | 1,241 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Grant not working

I am doing something wrong or have something set up wrong.

When I issue

mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.69 sec)

It looks like the grant worked. Here is what the mysql.user table looks
like.

mysql> select user,password, host from mysql.user;
+---------+---------------------+-----------+
| user | password | host |
+---------+---------------------+-----------+
| root | | localhost |
| root | | % |
| | 3823a5ee1f831626 | localhost |
| | | % |
| bruceaj | 426d920b373a5e5b | % |
| mike | 426d920b373a5e5b | % |
| peter | 426d920b373a5e5b | % |
| jim | 426d920b373a5e5b | % |
+---------+-----------------==-+-----------+

Now, when I issue a mysql command for mike, I get

C:\mysql\bin>mysql -u mike -pjoented;
ERROR 1045: Access denied for user: 'mike@localhost' (Using password:
YES)

The ONLY User I can login as is root, as:

mysql -u root

Appreciate your help in identifing what what I have screwed up, and how do I
fix it.

Thanks.....

Bruce
Jul 17 '05 #1
3 3797
On 2003-12-18, Bruce A. Julseth <br*****@attglobal.net> wrote:
When I issue

mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.69 sec)

It looks like the grant worked.


If i remember well, the manual says that you have to reload...

mysqladmin -u root -p reload
--
verum ipsum factum
Jul 17 '05 #2
Tim Van Wassenhove wrote:
On 2003-12-18, Bruce A. Julseth <br*****@attglobal.net> wrote:
When I issue

mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.69 sec)

It looks like the grant worked.

If i remember well, the manual says that you have to reload...

mysqladmin -u root -p reload


or
mysqladmin -u root -p flush-privileges

.... also not that you shouldn't publish passwords so you ought to change it.

Jul 17 '05 #3
I tried both,
mysqladmin -u root flush-privileges
and
mysqladmin -u root reload

NOTE: root has no password on purpose.

I still fail with the following scenario:

C:\Documents and Settings\Bruce A. Julseth>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.14-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.65 sec)

mysql> quit
Bye

C:\Documents and Settings\Bruce A. Julseth>mysql -u mike -pjoented
ERROR 1045: Access denied for user: 'mike@localhost' (Using password:
YES)

As for the "Open" password, this development is going on a private,
non-networked machine. But thanks for catching the potenial problem.

Now, I hope you folks out there is PHP land can provide some more
suggestions.

Bruce

"Kevin Thorpe" <ke***@pricetrak.com> wrote in message
news:3F**************@pricetrak.com...
Tim Van Wassenhove wrote:
On 2003-12-18, Bruce A. Julseth <br*****@attglobal.net> wrote:
When I issue

mysql> grant all on * to mike identified by 'joented' with grant
option;
Query OK, 0 rows affected (0.69 sec)

It looks like the grant worked.

If i remember well, the manual says that you have to reload...

mysqladmin -u root -p reload


or
mysqladmin -u root -p flush-privileges

... also not that you shouldn't publish passwords so you ought to change

it.

Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Martin v. Löwis | last post by:
The Python Software Foundation is seeking grant proposals for projects related to the further development of Python, Python-related technology, and educational resources. The PSF plans to issue...
2
by: Ralf | last post by:
Hi ! When I insert a new record to a table "table_A" I want to Grant a Role "Role_X" to the User "User_Y". So I made a Trigger who should do this work, but it doesn't: When I write: "GRANT...
4
by: Amardeep Verma | last post by:
Hi, I have a quick question. Which role/privileges are required before a user can give the statement "GRANT ALL PRIVILEGES"? Thanking you in Advance Have a nice day
0
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...
0
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...
1
by: Gregory Stone | last post by:
I've got a problem where any group or user permissions to the pg_class table aren't being registered by either psql or the JDBC driver. I issue the following command: GRANT ALL ON TABLE pg_class...
3
by: Chris Ochs | last post by:
Is there a shortcut to grant all privileges on a schema and it's objects to a user without having to issue GRANT statements for each individual object in the schema? Given all the possible types...
2
by: stmfc | last post by:
i have a problem with user creation for mysql db i think the problem stems from string style. GRANT ALL ON newDB.* TO 'test'@'localhost' IDENTIFIED BY 'test'; i am...
7
by: MNNovice | last post by:
Please forgive me for this is a long request. I am designing a DB to capture expenses related to Federal Grants and to generate appropriate reports. Each grant starts with a Notice of Grant Award...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.