Results 1 to 7 of 7

Thread: Problems connecting to MySQL

  1. #1

    Problems connecting to MySQL

    Hi,

    I am Linux Fedora and having problems connecting to MySQL despite being root. Here is the error when I type mysql at the prompt/terminal.

    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    Can any one help? Thanks...

  2. #2
    Did you recently change the users? If its a fresh install of MySQL, try logging in with root, without a password. I'm not sure if FC has you set a password on install, but some do not, leaving the password blank for root.
    arrogance breeds ignorance

    Screaming Electron, Full of BSD Goodness

  3. #3
    Quote Originally Posted by Kernel_Killer View Post
    Did you recently change the users? If its a fresh install of MySQL, try logging in with root, without a password. I'm not sure if FC has you set a password on install, but some do not, leaving the password blank for root.

    Thanks you...its working now for some weired reason it stopped...

  4. #4

  5. #5

    mysql

    just type

    #mysql

    mysql>

    grant the permissions to localhost

    mysql> grant all on * to root@localhost identified by "passwd";

    u can login with

    #mysql -u root -p

  6. #6
    don't forget to run "FLUSH PRIVILEGES" after editing mysql grant tables.
    63,000 bugs in the code, 63,000 bugs,
    ya get 1 whacked with a service pack,
    now there's 63,005 bugs in the code!!

  7. #7
    Hi always after successful installation of Mysql installation execute the command "mysql_secure_installation" command and set your preferences.

Similar Threads

  1. Problems installing MySQL++ wrapper for C++ language
    By tech291083 in forum Redhat / Fedora
    Replies: 5
    Last Post: 12-27-2010, 10:57 PM
  2. Problem starting mysql conflicts with the RPM "mysql-5.0.27-1.fc6"
    By kamakshiganesh in forum Redhat / Fedora
    Replies: 2
    Last Post: 10-26-2007, 04:35 AM
  3. mysql problems
    By pinehead in forum Linux - General Topics
    Replies: 12
    Last Post: 07-25-2004, 12:22 AM
  4. MythTV Problems-MySql
    By gmoreno in forum Linux - Software, Applications & Programming
    Replies: 3
    Last Post: 09-03-2003, 10:43 AM
  5. Solaris mysql config problems
    By coltrane in forum BSD
    Replies: 0
    Last Post: 09-19-2002, 04:07 PM

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
  •