tell mysql error

--0-899001001-1181072426=:92052
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi

i installed mysql and created a database.

when i try

use

command it says access denied reload privileges

when i gave command

reload privileges; at mysql prompt

or

mysqladmin flush-privileges

it says access denied reload privileges

and when i try to login by using password by


mysql -h localhost -u root -p 123456


it says

access denied (using password yes)

what should i do?

bye


Asim Jamil - 0092 345 4025907, Pakistan

---------------------------------
8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.
--0-899001001-1181072426=:92052--

Re: tell mysql error

Hi

> mysql -h localhost -u root -p 123456

should be:

mysql -h localhost -u root -p123456

notice no space after -p or it asks for the password.


Niel

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: tell mysql error

--0-871771632-1181329325=:7855
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi


thanks for your response but i tried it too and it shows

ERROR NO 1045

when i try to reload privileges it shows


ERROR NO 1066 or like that


what should i do?


bye






Niel Archer wrote:
Hi

> mysql -h localhost -u root -p 123456

should be:

mysql -h localhost -u root -p123456

notice no space after -p or it asks for the password.


Niel

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Asim Jamil - 0092 345 4025907, Pakistan

---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
--0-871771632-1181329325=:7855--

Re: tell mysql error

Hi

Sounds like you do not have the required privileges with your user
account.. I suggest you spend some time reading the MySQL documentation
on privileges.

Are you using the root account? Have you created other user accounts and
given them the required privileges?



Niel

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php