Solved

how do i grant permissions to my mysql db?

Posted on 2008-06-10
2
1,271 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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

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 article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
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.

636 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