Quick question about privilages

**hayward6** · #1 08-04-2006, 12:32 AM

What needs to be done to allow me privilages in sql? I have my server running fine on a seperate pc but I want to install a copy of the database on a laptop for editing purposes.

Thank you

mysql> create database peq;
ERROR 1044: Access denied for user: '@localhost' to database 'peq'
mysql>

**hayward6** · #2 08-04-2006, 02:04 AM

I found the answer. I had to do a few searches to find what I was looking for and I ran dos command to give access to user@localhost.

Angelox · #3 08-04-2006, 02:08 AM

Quote:

Originally Posted by hayward6

I found the answer. I had to do a few searches to find what I was looking for and I ran dos command to give access to user@localhost.

Again, there's another program at the Mysql site downloads called "MySQL Administrator" , gives you a "visual" on all that, makes it easier.

http://dev.mysql.com/downloads/

Also works from a remote PC.