SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: phpmyadmin

  1. #1
    SitePoint Member
    Join Date
    Aug 2013
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    phpmyadmin

    Hello ,
    I install in my computer Xampp apache becouse and i want to use mysql. I made all settings and when i try to log in in phpmyadmin I can't do this becouse an error message apair saying" 1045 error cannot log to server ". After this I open shell and i type there the following code " mysql> GRANT ALL PRIVILEGES ON *.* TO user@localhost AFTER THAT ,I PRESS ENTER AND ON THE NEXT ROW APPAIR AN ARROW AND NEAR ARROW I TYPE "WITH GRANT OPTION;
    AFTER THIS PROCEDURE ON THE SHEEL APAIR THE NEXT MASSAGE "#1045 ERROR<28000> Access denied for user 'root'@'localhost' (using password: NO). Please help me to fix this problem. Is so important to me.

  2. #2
    SitePoint Mentor silver trophy
    Rubble's Avatar
    Join Date
    Dec 2005
    Location
    Cambridge, England
    Posts
    2,413
    Mentioned
    81 Post(s)
    Tagged
    3 Thread(s)
    You should not have needed to grant any user permissions and I have installed XAMPP loads of times without a problem.
    If you want to setup a user you can use the XAMPP interface or edit the password file.

    Have you started Apache and MySQL from the XAMPP control panel?

    From memory the standard user is Root without a password

  3. #3
    SitePoint Wizard
    Join Date
    Oct 2005
    Posts
    1,834
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)
    I recently installed XAMPP and had problems getting everything running from the XAMPP control panel until I right-clicked on some file (I think it was xampp-control.exe) and chose to run as administrator. After I did that everything worked fine. There is no MySQL password on the default installation of XAMPP. Once everything is running you can access MySQL using phpMyAdmin without concern about credentials.


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •