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
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.