Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how do i grant permissions to my mysql db?

Posted on 2008-06-10
2
Medium Priority
?
1,284 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
2 Comments
 
LVL 4

Accepted Solution

by:
albuitra earned 1600 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

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…
Often times it's very very easy to extend a volume on a Linux instance in AWS, but impossible to shrink it. I wanted to contribute to the experts-exchange community a way of providing a procedure that works on an AWS instance. It can also be used on…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses

580 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