phpmyadmin is frustrating me

[afon]

Create new database: [Documentation]
No Privileges

I cant create databases, and i get the error:
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

What the hell is going on here? Im trying to set up a script and im ready to pull my hair out. I followed the tutorial 100%

[senshi]

I will put my money on MySql is the issue, I looked at an older machine running an older version of the program, I then duplicated the structure with the latest mSql and IM getting nowhere and feel it is an issue with the mySql program, the older install functions perfectly, which I cant see what difference their is, so I draw my conclusion to be mySql is the problem.

Try an older version of the program and try again, I say this because I have been looking at the number of posts since the latest release of the mySql binarys and theirs been a marked increase in the number of people having issues with the database.

Before you go running to mySql to inform them, beaware, your rants and fustrations will go unanswered, unless you want to spend money with them.

[The-Hunter]

Have you tried MySQL-Front. I think its a much easier program to use than phpMyAdmin. Here is the URL: http://www.mysqlfront.de/ I have had to many problems with phpMyAdmin, I usually use the command console but sometimes i do go back to MySQL-Front. You can manage your users and databases easier and more reliably. I have seen instances where phpMyAdmin has corrupted databases.

Hope this helps. =)
_________________
The-Hunter

[PintSki]

"Your configuration file contains settings (root with no password)
that correspond to the default MySQL privileged account. Your MySQL
server is running with this default, is open to intrusion, and you
really should fix this security hole."

Don't worry now you have the GUI to easily password protect your
MySQL... Go to Privileges and edit each user on the list and assign each
user a password...

Now if after assigning passwords to each user you happen to get locked
out of accessing phpMyAdmin don't worry... go back into config.inc.php
and edit lines 74 and 75 and enter the correct values...
NOTE: in my version the correct line was nr 84 for the password, your looking for: $cfg['Servers'][$i]['password'] ='passhere'

from topic:http://www.aprelium.com/forum/viewtopic.php?t=1071