Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: C. Schmid on January 26, 2003, 11:55:24 PM

Title: Can't access MySql
Post by: C. Schmid on January 26, 2003, 11:55:24 PM

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

Title: Re: Can't access MySql
Post by: Dan Brown on January 27, 2003, 12:00:00 AM

Hmmm, tried searching here maybe?

Title: Re: Can't access MySql
Post by: C. Schmid on January 27, 2003, 12:12:23 AM

Hi

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

Title: Re: Can't access MySql
Post by: Dan Brown on January 27, 2003, 12:17:23 AM

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'.

Title: Re: Can't access MySql
Post by: C. Schmid on January 27, 2003, 01:58:38 AM

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 ;-)

Title: Re: Can't access MySql
Post by: Dan Brown on January 27, 2003, 03:13:53 AM

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.

Title: Re: Can't access MySql
Post by: trbonja on January 27, 2003, 09:22:32 PM

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

Title: Re: Can't access MySql
Post by: C. Schmid on January 28, 2003, 11:42:59 AM

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.

Title: Re: Can't access MySql
Post by: Steve on January 28, 2003, 12:11:55 PM

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

Title: Re: Can't access MySql
Post by: Danne on February 10, 2003, 12:29:10 PM

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.