Results 1 to 3 of 3

Thread: phpmyadmin & mysql problem

  1. #1
    Junior Member
    Join Date
    Aug 2011
    Posts
    1

    Exclamation phpmyadmin & mysql problem

    I just recently installed phpMyAdmin on local computer for testing purposes. However, I am experiencing mysql connection on it. I used root@localhost but it's telling me that I couldn't connect to the database. But I know that both my username and the password are correct, so I thought that the problem might be from the hosted server, maybe my sql isn't connected to localhost or something? I am really new to this so I couldn't be sure, is there a way to tell what server the mysql has from the mysql console? Or are there other ways to do so?

  2. #2
    Senior Member mungyun's Avatar
    Join Date
    Apr 2004
    Location
    Illinois
    Posts
    172
    Where is the MySQL database you are trying to access located at? Is it on the same computer as your PhpMyAdmin install?

    I would say to make sure that PhpMyAdmin is looking at the correct place for your MySQL database.
    I believe in making the world safe for our children, but not our children’s children, because I don’t think children should be having sex. -- Jack Handey

  3. #3
    Senior Member Opus00's Avatar
    Join Date
    May 2005
    Posts
    143
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION

    http://dev.mysql.com/doc/refman/5.0/...ing-users.html
    http://dev.mysql.com/doc/refman/5.5/...rmissions.html
    There are two rules for success in life:
    Rule 1: Don't tell people everything you know.

Similar Threads

  1. Read Me First
    By Negative in forum The Security Tutorials Forum
    Replies: 12
    Last Post: June 2nd, 2004, 01:09 AM
  2. Spam problem
    By FamStars&Straps in forum Miscellaneous Security Discussions
    Replies: 2
    Last Post: October 12th, 2003, 05:33 AM
  3. MySQL 3.23.54a released...
    By -DaRK-RaiDeR- in forum AntiOnline's General Chit Chat
    Replies: 1
    Last Post: December 30th, 2002, 07:25 PM
  4. C problem...
    By Rna in forum General Programming Questions
    Replies: 4
    Last Post: May 22nd, 2002, 07:03 AM
  5. Problem installing MySQL
    By tiger_r_ in forum Newbie Security Questions
    Replies: 5
    Last Post: May 17th, 2002, 05:38 PM

Posting Permissions

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