MYSTERY ZILLION တွင် English သို့မဟုတ် Unicode ဖြင့်သာ အသုံးပြုခွင့်ရှိသည်။ ဇော်ဂျီ ၊ ဧရာ စသည်တို့ကို အသုံးပြုခွင့် မရှိ။ Unicode Guide ကို ဒီမှာ Download ချပါ။ Zawgyi to Unicode Converter
Don't share ebook or software if nobody request. You can find free book websites on here. We are welcome for discussion or asking question instead.
I removed username "root" inside Privileges in Phpmyadmin
  • Vote Up0Vote Down suchinsuchin
    Posts: 74Registered Users
    I created new user name with password inside Privileges in Phpmyadmin.
    Then i removed "root" with blank password inside Privileges.
    After removing "root", the following Error was came out.

    I think Database should have "root". Why shouldn't ? How could i sort out for that error?

    Please help me !
    Many Thanks !

    "
    Error

    MySQL said: Documentation
    #1045 - Access denied for user 'root'@'localhost' (using password: NO)
    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
    "
  • 6 မှတ်ချက်များ sorted by
  • Vote Up1Vote Down saturngodsaturngod
    Posts: 4,599Administrators
    you need to change database username and password in phpmyadmin config file (config/config.inc.php).
  • Vote Up1Vote Down saturngodsaturngod
    Posts: 4,599Administrators
    in xampp , phpmyadmin config file in

    \xampp\phpMyAdmin\config.inc.php

    can you login mysql from CMD ?

  • Vote Up1Vote Down suchinsuchin
    Posts: 74Registered Users
    Everything Okay Now !!!!!!!!!!! :-D :-D
    http://localhost/phpmyadmin is working.
    I put the new row which is the name with "root".
    Very easy ! ^^
  • Vote Up0Vote Down suchinsuchin
    Posts: 74Registered Users
    I'm using xampp. I can't find config.inc.php. Found out this ->config.default.php
    change the password like following :
    $cfg['Servers'][$i]['password'] = 'apple';
    But the error still showing.

    ----------

    also tried like this.
    UPDATE mysql.user
    ->SET Password=PASSWORD("*******")
    ->WHERE User="root";

    xampp/mysql/bin>mysql>UPDATE mysql.user SET Password=PASSWORD("apple") Where User="root";

    Still can't

    -----------

    also tried :
    change :

    $cfg['PmaAbsoluteUri'] = '';

    to

    $cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';

    change

    $cfg['Servers'][$i]['host'] = 'localhost';

    to

    $cfg['Servers'][$i]['host'] = 'Localhost';

    and enter you're password in :

    $cfg['Servers'][$i]['password'] = '';

    eg

    $cfg['Servers'][$i]['password'] = 'password';

    still not working #-O

    Thank you for your quick reply !
  • Vote Up0Vote Down suchinsuchin
    Posts: 74Registered Users
    Inside config.inc.php, I put $cfg['Servers'][$i]['password']= 'MyPassword';
    also can't login from CMD.
    If put the password, the error has shown like this :
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

    if no password, the error has shown:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

  • Vote Up0Vote Down suchinsuchin
    Posts: 74Registered Users
    I can login from CMD with
    >mysql -u mydatabase -p
    >mypassword

    then i wrote
    >SELECT Host,User From mysql.user;

    I saw 2 Users : mydatabase & pma.
    I think actually it should be 3 Users: mydatabase, pma & root.
    Because i removed root. There's just only 2 Users & having Error 1045.

    http://localhost/phpmyadmin is not working yet.

Add a Comment
ဆွေးနွေးမေးမြန်းခြင်းစတင်ရန်

မင်္ဂလာပါ!

လှိုက်လှဲစွာကြိုဆိုပါသည်။ ယခု ပထမဆုံးအကြိမ် ရောက်ဖူးခြင်းဖြစ်ပါသလား? ဝင်ရောက် ဆွေးနွေး မေးမြန်းလိုပါလျှင် အောက်တွင်ဖော်ပြထားသော button များမှတဆင့် ဝင်ရောက် ဆွေးနွေးနိုင်သကဲ့သို့ အဖွဲ့ဝင်အသစ်အနေဖြင့်လည်း လျှောက်ထားနိုင်ပါတယ်။

Facebook ဖြင့်ဝင်ရန် Google ဖြင့်ဝင်ရောက်ရန် OpenID ဖြင့်ဝင်ရောက်ရန် Twitter ဖြင့်ဝင်ရောက်ရန်
ဝင်ရောက်ရန် အဖွဲ့ဝင်အဖြစ် လျှောက်ထားခြင်း

အမျိုးအစားများ

In this Discussion

Tagged