Solved

how do i grant permissions to my mysql db?

Posted on 2008-06-10
2
1,267 Views
Last Modified: 2013-12-16
ok, i just created an app and db on my local system.  we are now using linux os.  I have moved the code to the server, created the db and now I need to add the tables and data which are all located in an .sql files. after creating the db i did this:

grant all privileges on compx to compx identified by 'compx20';

  grant all privileges on compx to compx@localhost identified by 'compx20';

  update mysql.user set password=OLD_PASSWORD('compx20') where user='compx ';

  flush privileges;

i load my .sql file and get 1044-access denied for user 'compx@% to database mysql.  I am using mysql qui (navicat) and i know locally, i had to go to manage users and select everything, edit, create, etc and save it.  I thought all the granting above would take care of that.  Now I am wondering if I have to somehow grant edit, create, delete, etc for the db that is on the linux server.  

any help would be appreciated.
0
Comment
Question by:justmelat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
albuitra earned 400 total points
ID: 21754651
Try with this
grant all privileges on compx.* to compx@localhost identified by 'compx20';
0
 
LVL 1

Author Comment

by:justmelat
ID: 21754800
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question