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
mysql command line
Moderator: General Moderators
- Pyrite
- Forum Regular
- Posts: 769
- Joined: Tue Sep 23, 2003 11:07 pm
- Location: The Republic of Texas
- Contact:
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.
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
Or MySQL Control Center, which I always use:
http://www.mysql.com/products/mysqlcc/screenshots.html
http://www.mysql.com/products/mysqlcc/screenshots.html
- 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
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!
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!