Forum Moderators: coopster

Message Too Old, No Replies

phpmyadmin, connect through terminal not through browser

         

Sharky01276

6:04 pm on Feb 26, 2006 (gmt 0)

10+ Year Member



Basically its the title,

After changing my password via phpmyadmin then trying to log on again i got a access denied error. However i can connect fine using this new password via the terminal.

Tried loads of things nothing has worked properly. Any help would be welcomed thanks in advance

More info


mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using readline 5.0

Connection id: 18
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.18-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 31 min 47 sec

Threads: 1 Questions: 142 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 7 Queries per second avg: 0.074


$i++;
$cfg['Servers'][$i]['host'] = '127.0.0.1'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type

There ya go , Thanks in advance.

Alan

phparion

8:24 pm on Feb 26, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



first of all welcome to webmasterworld! you need to check the "config.default.php" page to check whether your new password is there in the file or not? next you have to change the password for DB in your connection pages for your already running websites to match it with the new password.

Sharky01276

8:45 pm on Feb 26, 2006 (gmt 0)

10+ Year Member



well thats the thing. THe user name and password for my other sites still works fine. However i cant use that in phpmyadmin either...

Sharky01276

8:48 pm on Feb 26, 2006 (gmt 0)

10+ Year Member



and secondly. config.default.php is just the default set up of config.inc.php, it has no function over phpmyadmin. THe bits with the passwords in config.inc.php is what ive posted above :) Thanks for your help and welcome!

Alan