mysql command line

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

mysql command line

Post by pelegk2 »

i have being working in window using the dos shell
i have connected the db using user name and password
then i have connected 1 of the databases

when i tred to make a select on a tabale i got this error :
error 1044 : access denided for user peleg to database "bla bla"

why is that?can any 1 help?thanks in advance
peleg
hibbard
Forum Newbie
Posts: 11
Joined: Sun Nov 02, 2003 1:15 pm

Post by hibbard »

it means you didn't setup your priv's correctly for the user. meaning, you didn't grant him read/write/drop access to that table..

in other words, you need to grant him new privileges. you can find that information in your user's manual.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

I don't know about you, but I find everything in the MySQL CLi a bit confusing. Why not try phpMyAdmin?

http://www.phpmyadmin.net/

Its really easy from there to run queries, and setup different users and their permissions etc.
microthick
Forum Regular
Posts: 543
Joined: Wed Sep 24, 2003 2:15 pm
Location: Vancouver, BC

Post by microthick »

Or MySQL Control Center, which I always use:
http://www.mysql.com/products/mysqlcc/screenshots.html
User avatar
pelegk2
Forum Regular
Posts: 633
Joined: Thu Nov 27, 2003 5:02 am
Location: Israel - the best place to live in after heaven
Contact:

good mornning

Post by pelegk2 »

i found the problem
beacuse i tried to access my ip
instead of using ip 127.0.0.1
when i did it everythin works just fine:)

the 2 olls u gave me are great but the whole point i want to learn to work from command line!
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Well best of luck to you then.
Post Reply