Page 1 of 1

mysql command line

Posted: Mon Dec 01, 2003 7:28 am
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

Posted: Mon Dec 01, 2003 9:48 am
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.

Posted: Mon Dec 01, 2003 11:50 am
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.

Posted: Mon Dec 01, 2003 11:53 am
by microthick
Or MySQL Control Center, which I always use:
http://www.mysql.com/products/mysqlcc/screenshots.html

good mornning

Posted: Tue Dec 02, 2003 12:16 am
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!

Posted: Tue Dec 02, 2003 2:40 am
by Pyrite
Well best of luck to you then.