Hello guys i'm having problem with MYSQL on my local machine, i tried to connect to mysql from command line it returns this error back
"cannot connect to mysql, Access denied for root@localhost" But i can connect to MySQLAdmin,PHPMyAdmin don't know what went wrong.
have tried to see what the problem is but still tells me i can't connect i reset the root password from MySQLAdmin, still got the same error message. Anyhelp i will be greatfull. lest i forget i use MySQL5.0.1.1

meehn, dat thing don suffer me many times, but u can use this code to solve it

SELECT Host, User, Password FROM mysql.user
WHERE LENGTH(Password) > 16;

UPDATE mysql.user SET Password = OLD_PASSWORD('password')
WHERE Host = 'localhost' AND User = 'root';
 FLUSH PRIVILEGES;

obviously, ur new password shld be "password" after u run d script,

let me knw if it works, safe

Go to your MySQL command Line Client and run this code:

CONNECT mysql;

UPDATE user SET Password = OLD_PASSWORD('type your desired password here')
WHERE host = 'localhost' AND user = 'root';


To confirm the effect, run this code:

SELECT password from user where host='localhost' AND user='root';

NOTE: you can as well change the hostname and username using the same method.

I hope this helps.

Thank you guys, well i have done that before posting this topic here it all the same the problem is not the code to reset the passsword, the problem is  when i open DOs environment, if i try typing Mysql and press the enter button, it will display that error for me,  but if i open my MysqlAdmin. or go to PHPMyAdmin i can go in freely and do whatever i want to do.

what i can't do is type Mysql on my command line.

if u r logged on as root

UPDATE user SET Password=PASSWORD('typeinnewpasswordhere') WHERE User='root';
FLUSH PRIVILEGES;

smartsoft:

the problem is when i open DOs environment, if i try typing Mysql and press the enter button, it will display that error for me, but if i open my MysqlAdmin. or go to PHPMyAdmin i can go in freely and do whatever i want to do.

what i can't do is type Mysql on my command line.

Smartsoft, I now understand your plight.

Don't just type only mysql in your (DOS) command prompt; since it doesn't let you login as annonymous.

Try this (still in the DOS environment):

mysql -u root -p (then hit ENTER)

the '-p' is to let you enter your password; the next line will do just that, then type your password and hit ENTER.

I beleive this will work, if it doesn't, I advice that you always use the "MySQL Comand Line Client"

Please let us know if this works. SUCCESS!!!

bros men, this Mysql is a pain in my ass. i enter mysql -u root -p and hit my enter button still gives me the same error

Access Denied for users root@localhost (using password : Yes )

If it is not working and you intend on working on a windows platform i suggest you get WAMP @ http://www.wampserver.com/en/

that gives you a full package install of apache2.2, php5, mysql5 (i think) then you can then go into the httpd, php.ini to do your manual configuration as required.

smartsoft:

bros men, this Mysql is a pain in my ass. i enter mysql -u root -p and hit my enter button still gives me the same error

Access Denied for users root@localhost (using password : Yes )

your mistake: mysql -u root -p and hit my enter


you should write : mysql -u root -p typeinyourpasswordhere

and hit enter

you forgot to type in your password lol. gl

-u = username = root
-p = password = yourpassword

smartsoft:

bros men, this Mysql is a pain in my ass. i enter mysql -u root -p and hit my enter button still gives me the same error

Access Denied for users root@localhost (using password : Yes )

Please try and do that again, it will definitely ask for your password: make sure you enter the password correctly. Keep Cracking

Have tried that my brother same thing i wish i could have the print screen here and see where i type in my password.

When i hit the enter button, it prompt me for password which i entered and still same thing.

Well it seems it depend on the kinda webserver i'm using. cos i'm using APACHE2TRIAD

@Smartsoft

I don't think it has anything to do with your web server: MySQL is a database server; and should run effectively (if properly installed) on your local system even if no web server is installed.

Have you tried accessing your databases through the MySQL Comand Line Client, if no, try using it and let see what happens.

Yah it working as root access

You can as well try it using the Query browser which is the gui for mysql db or if u have phpmyadm setup up.

another option is to create a new user and granting full privilege just like the root access.

So,

There r 2 ways to work: working hard and working smart. I have used both the DOS prompt and phpadmin. To me, the latter is easier and smarter in my opinion. Y not just go with phpadmin and get what you want to do done in seconds as opposed to spending posting time upon posting time scratching your head to get it done via DOS prompt?

That's my take anyways. Then again, I am known to be a very lazy person

Good luck to you, regardless of the approach you take.