Topic: Can't access MySql

[C. Schmid]

Hi

I am using 5.6 with all updates installed, phpMyAdmin has been installed, but cannot connect with the standard Username and Password created on the Setup start.

What to hell is the Standardpassword to access the Mysql Database over phpmyadmin ??

The confic.inc.php ask for :

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['user']          = 'admin or root or ????';      // MySQL user
$cfg['Servers'][$i]['password']      = '?????';          // MySQL password (only needed

[Dan Brown]

Hmmm, tried searching here maybe?

[C. Schmid]

Hi

Yes but there was nothing to find about this problem ;-(

[Dan Brown]

No, I know better than that.  Be sure to search beyond the last 30 days, and try some really off-the-wall search terms, like 'mysql password'.

[C. Schmid]

Hi

Sorry it's me again couldn’t find any information about the Username and Password to get access to MySql.

I'm a newbie about MySql it is possible that I need to create first a user with password on the Command line to get any access to the MySql-Database??
In the paste I used phpmyadmin to get access to create a user or database in MySql.

Sorry for my bad English I hope you can understand my Questions

[Dan Brown]

Try taking a look here (which was found using the search I recommended):

http://forums.contribs.org/index.php?topic=5900.msg20972#msg20972

Also found a few references to http://www.familybrown.org/howtos/mysql-password-howto.html , which would also answer your question.

[trbonja]

Can you connect to mysql through ssh? If you can just create one more account for your phpmyadmin - and enter that info in to the config files for phpmysql, if posible use only one database through phpmyadmin not whole mysql

[C. Schmid]

First of all Thank's to Dan

The Howto doc was the right one.
Thank's as well to trbonja ,yes it's possible to connect over ssh to the MySql but the problem is still that phpmyadmin just provide one Database and not whole mysql. That meens for every single Database i need to reconfigure phpmyadmin config.inc.php.
Only the Root-account provides the full access to MySql over phpmyadmin !!
But the Root - Password is a 76-character random string stored in the file /root/.my.cnf witch can't be readed or better is not accepted by the MySql.

Thank's to all for your support it's a very good Forum here.

[Steve]

Doesnt any users with all privilages enabled give access to all functions ?

[Danne]

Don't know if you solved the problem but I had a similar problem earlier and solved it with help from this forum..

I added an dummy user from the mysql commandline..

FIrst logged in as root, start mysql console by typing mysql and press enter.

Say your dummy user's name is mysqluser, enter the following:

GRANT ALL PRIVILEGES ON databasename.* TO mysqluser@localhost IDENTIFIED BY 'password';

Databasename is the name of the database.. For full access, enter mysql.*

Password is the password you will enter in te config.inc.php

NOTE! All sql commands MUST end with an ; I missed that and had to spend almost a day searching the net for solutions  :[

That worked for me, now I'm running phpmyadmin.