Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how do i grant permissions to my mysql db?

Posted on 2008-06-10
2
Medium Priority
?
1,277 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 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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

730 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