473,326 Members | 2,081 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,326 software developers and data experts.

Granted User Cannot Access Database (help please)

Hello all,

I'm relatively new to mysql and I'm having some trouble creating a user
that can access a database that I've created.

Here's what I've done:

1. As root, created a database called "tool_competence".
2. As root, created a couple of tables in the tool_competence db.
3. As root, created a user "called tool_comp_user" and flushed
privileges:

mysql> GRANT select, insert, update
-> ON tool_competence.employee_info
-> TO tool_comp_user@"%";

4. As root, checked grants using "show grants for tool_comp_user;" and
it reflects the granted privileges.
5. Logout of mysql and login as tool_comp_user: "mysql -u
tool_comp_user"
6. As tool_comp_user: "use tool_competence;" and I get the following
error:
ERROR 1044 (42000): Access denied for user ''@'[mydomain].com' to
database 'tool_competence'

Does anyone see anything wrong with this process or have any idea what
might be causing my problems?

Thanks in advance for any help,
Bart

Jul 23 '05 #1
1 1480
sp********@jam.rr.com wrote:
ERROR 1044 (42000): Access denied for user ''@'[mydomain].com' to
database 'tool_competence'


I realize now that in the above error message, user is ''. Why it did
not recognize the user when I logged in, I don't know. For some reason
it is now recognizing the user correctly and everything is working as I
would expect.

Very wierd because I was very careful about how I was logging in. And
haven't changed the way I was logging in since the problem was
occuring.

Although it appears not to be an issue now, I would gladly accept any
insights into what may have been going on if anyone out there has any
theories.

Thanks,
Bart

Jul 23 '05 #2

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

Similar topics

1
by: spambuster | last post by:
Hello all, I'm relatively new to mysql and I'm having some trouble creating a user that can access a database that I've created. Here's what I've done: 1. As root, created a database called...
9
by: Ping | last post by:
Hello, Have a wonderful new year! I have oracle 9.2 on XP. There is a table T1 created by user U1 in U1's schema, a synonym S1 created also by U1 to point to T1 in U1's schema, U1 granted...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
1
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
3
by: hary08 | last post by:
im doing a database for Hospital Admission, I have a log in form which prompt user for a password. The source of log in is to look for the values in my Table tblEmployees and match user name and...
2
by: bbasberg | last post by:
I have been working hard to clean up my code but I am still wondering why all incoming records go to the "AddNew" part of the IF statement and never to the Edit alternative. I believe that it must be...
0
by: kkos | last post by:
I noticed the following issue posted as a double-hop issue in many discussion boards but found no answers that explain how to pass the second hop with windows auth from IIS ASPX page to remote SQL...
13
JodiPhillips
by: JodiPhillips | last post by:
G'day, I have a silly and simple problem that I need some guidance with. Due to the way our network is set up, I am unable to use the group permissions for Access and have had to implement log...
9
by: Gordon | last post by:
I want to add a feature to a project I'm working on where i have multiple users set up on my Postgres database with varying levels of access. At the bare minimum there will be a login user who...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.