XAMPP MySQL password setting (Can not enter in PHPMYADMIN) -


firstly: cannot entering phpmyadmin @ "localhost:80/phpmyadmin/". because when install mysql server mysql-5.5.36 username :root , password : hamdunsoft . after when enter localhost:80/phpmyadmin/ show me message below .

"error mysql said: documentation 1045 - access denied user 'root'@'localhost' (using password: no) connection controluser defined in configuration failed. phpmyadmin tried connect mysql server, , server rejected connection. should check host, username , password in configuration , make sure correspond information given administrator of mysql server."

now want enter phpmyadmin though have setup 2 mysql server 1 in xampp, mysql-5.5.36. have searched in net content not helpful sufficiently. how can set password in xampp before login in phpmyadmin .

another different issue is: xampp apache server saying : port 80 being used one. solved stopping skype. again having types of problem. think skype software using port 80. want use port apache wish. may port 80 or 81 or 82. if other process using desired port want replace , give port apache.

find below code in xampp/phpmyadmin/config.inc.php

$cfg['servers'][$i]['controluser']  = 'user_name/root';    $cfg['servers'][$i]['controlpass']  = 'passwaord'; $cfg['servers'][$i]['auth_type']    = 'config'; $cfg['servers'][$i]['user']         = 'user_name/root'; $cfg['servers'][$i]['password']     = 'password'; 

replace each statement above corresponding entry below:

$cfg['servers'][$i]['controluser']  = 'root';    $cfg['servers'][$i]['controlpass']  = 'xxxx'; $cfg['servers'][$i]['auth_type']    = 'config'; $cfg['servers'][$i]['user']         = 'root'; $cfg['servers'][$i]['password']     = 'xxxx'; 

doing caused localhost/phpmyadmin in browser , mysql command prompt work properly.


Comments

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

android - Keyboard hides my half of edit-text and button below it even in scroll view -

css - Make div keyboard-scrollable in jQuery Mobile? -