xampp & mysql password help (arxarios :-p )

[guido]

egkatesthsa to xampp kai akolou8ontas tis odhgies sthn selida tou ekana ta ekshs:

 

\...\xampp\mysql\bin\mysqladmin -u root password secret

 

Attention. After changing the password for root, don't forget to inform PHPMyAdmin. Search the "config.inc.php" under \...\xampp\phpmyadmin\ and edit the following lines:

 

$cfg['Servers'][$i]['user'] = 'root'; // MySQL SuperUser

$cfg['Servers'][$i]['auth_type'] = 'http'; // HTTP MySQL authentification

 

Now the correct password for "root" is required, before PHPMyAdmin starts.

 

Afou ekana ta parapanw opote mpainw phpmyadmin mou bgazei:

 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.

 

Epeidh eimai arxarios teleiws mporei kanenas na me boh8hsei ti akribws mporei na phgainei la8os?

 

euxaristw

[magma]

// You can disable a server config entry by setting host to ''.

$i++;

$cfg['Servers'][$i]['host'] = 'localhost'; // 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'] = 'pma'; // 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'] = 'config'; // Authentication method (config, http or cookie based)?

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user

$cfg['Servers'][$i]['password'] = 'MYPASSWORD'; // MySQL password (only needed

// with 'config' auth_type)

$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only

// this db is displayed in left frame

// It may also be an array of db-names, where sorting order is relevant.

$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname

 

 

H moni diafora pou blepw einai oti to auth_type einai set sto config se mena enw sto http se sena. Me ayto ton tropo mpainei katey8eian sto phpMyAdmin . Fantazomai oti me to diko sou (auth=http) 8a prepei na sou zitaei to password alla den to kanei gia kapoio logo. Dokimase kai opws einai to diko mou kai blepeis.

[guido]

euxaristw polu.

 

8a to koitaksw kai 8a enhmerwsw