ERROR: latin1

[romalong]

I've set a password for root localhost through phpmyadmin.
The next time i tried to use phpmyadmin it doesn't let me in! It says: Access denied for user:
'root@127.0.0.1' (Using password: NO). How can i solve this problem?
Also when i type in command prompt from C:/AppServ/mysql/bin>mysqlqdmin -h it says
mysqladmin: ERROR: unknown variable 'default-character-set=latin1'.
The same error message was when i tried to change pass typing: mysqladmin -u root password
"your new password"
P.S.That was default option (latin1) when i installed AppServ.
Thanx!

[raf]

Welcome here.

Read this thread + maybe the chapter in the tutorial i refer to inthere.

http://www.codingforums.com/showthread.php?s=&threadid=19369&highlight=login

Also, make sure you flushed the priviledges after altering the userinfo.
mysqladmin flush-privileges;

[romalong]

I can not work in command line!

When type in C:/AppServ/mysql/bin>
any command regarding mysqladmin it says:
mysqladmin: ERROR: unknown variable 'default-character-set=latin1'.

???????????????????

[raf]

Did you (or does phpMyAdmin) flushes the priviledges after you changed the password? Or did you restart the machine (or the MySQL-server) since then?
What did you type at the prompt?
-->mysqlqdmin -h ?
I suppose that is a typo and just part of the command?

You need

mysqladmin -u root -p status

When you enter, you will be prompted for your password. (you can leave the ' status' of if you want)

Don't know about the character sets. Never had to tuch that.

[romalong]

Ok!

Do U know how to set: $cfg['Servers'][$i]['controlpass'] = ' ';
in the config.inc.php? What syntax?
It says:Access denied for user: 'root@127.0.0.1' (Using password: YES)

It will not let me in until i set it.

[raf]

Well, i assume the commandline thing worked, so your password was changed.
config.inc.php is a server side include that is used for phpMyAdmin. It's basically just an ordinary PHP file. So you can edit it with notepad or whatever editor you use to write your PHP-files (directly on the server, or after downloading it and uploeding itafter editing). (the .php is added so the file is always parsed when you try to open it through the browser)

But i don't know to what value it needs to be set. (never installed phpMyAdmin. I'm using MySQL-Front and commandline at home.) But check out the documentation at the site you got download from, or from
http://www.phpmyadmin.net/documentation/

[romalong]

Thank You buddy!

[raf]

You're welcome :thumbsup: