Re: 'Login without a password is forbidden by configuration'

[r dopfel]

Thanks.

I am really not a novice programmer but I am relatively new to phpMyAdmin and how this platform relates to MySQL databases. Actually.... I already know a lot of phpMyAdmin and MySQL navigation, table creation and mining. I am just stuck because I locked myself out.

When you say, if you can get into terminal as 'root'...... Type these commands.
The commands you suggested I type....what are they actually doing ?


From terminal, I do Not log in as root. I use sudo.

Can you explain what permissions I actually changed ?
What I messed up or corrupted.
PhpMyAdmin? MySQL?

These settings are still reflected in my config.inc.php file.
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
But I cannot login like that from the phpMyAdmin login window:
localhost/phpMyAdmin/
Why not ?

I do not understand the connection.
I do not understand what I should type at the mysql> prompt.

Sorry that i need explanation but I like to understand the file structure and permissions and relations between things.
I like to understand what I am doing.

Thanks again for taking the time to respond.