Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: glc on November 13, 2001, 05:33:30 AM

Title: phpMyAdmin
Post by: glc on November 13, 2001, 05:33:30 AM

Installed it but the page doesn't come up when trying to access it, so I tried the standard phpMyAdmin and it returns the following:
Error
MySQL said:


MySQL Connection Failed: Access denied for user: 'regardlessofuser@localhost' (Using password: YES)

How do I get either working?

TIA>

Title: Re: phpMyAdmin
Post by: peter on November 13, 2001, 05:57:16 AM

It seems you´d have to grant access for that user befor accessing the db.

Have fun,
Peter

Title: Re: phpMyAdmin
Post by: glc on November 13, 2001, 09:25:34 AM

peter wrote:
>
> It seems you´d have to grant access for that user befor
> accessing the db.
>
> Have fun,
> Peter
How do I do that?

Title: Re: phpMyAdmin
Post by: Richard Whitney on November 13, 2001, 05:47:38 PM

GRANT ALL ON databasename to 'regardlessofuser, password' ;

or just use root to access the database

Title: Re: phpMyAdmin
Post by: glc on November 13, 2001, 07:02:48 PM

Richard Whitney wrote:
>
> GRANT ALL ON databasename to 'regardlessofuser, password' ;
>
> or just use root to access the database

Where is this setting located?  config.inc.php?

Title: Re: phpMyAdmin
Post by: Richard Whitney on November 13, 2001, 07:29:14 PM

login to the server as root

type:  mysql

type:  use database dbname
type:  GRANT ALL ON dbname TO 'username, password';

or, to use root as username, find $username ="";  - put root between the ""

Title: Re: phpMyAdmin
Post by: glc on November 13, 2001, 08:48:29 PM

Richard Whitney wrote:
>
> login to the server as root
>
> type:  mysql
>
> type:  use database dbname
> type:  GRANT ALL ON dbname TO 'username, password';
>
> or, to use root as username, find $username ="";  - put root
> between the ""
I still get access denied.  Is there a file I need to edit manually on SME?

Title: Re: phpMyAdmin
Post by: glc on November 13, 2001, 08:52:20 PM

root doesn't work either

Title: Re: phpMyAdmin
Post by: glc on November 15, 2001, 01:05:43 AM

ok, now it's complaining about the mysql.sock:
ERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (111)

please help...

Title: Re: phpMyAdmin
Post by: glc on November 15, 2001, 04:16:44 AM

OK, solved the mysql.sock problem by removing and reinstally the 4 rpms used for mysql.  I can use phpMyAdmin using w/ the user root, but typing mysql at the console yields the following:
ERROR 1045: Access denied for user: 'root@localhost'  (Using password: YES)

How can this be if root can login w/ phpMyAdmin?