Results 1 to 6 of 6

Thread: Acessing The MySQL Command Line

  1. #1

    Lightbulb Acessing The MySQL Command Line

    Hi, i install Fedora core 3 on my machine and also MySql to play with database.but am having problems accessing The MySql Command line.
    i Keep getting Error 1045: Access denied for user ' root@localhost. what do i do pls?
    am a newbie.

  2. #2
    Code:
    mysqladmin -u root password yourrootsqlpassword
    mysql -u root -p
    My crime is that of curiosity. My crime is that of judging people by what they say and think, not what they look like. My crime is that of outsmarting you, something that you will never forgive.

  3. #3
    thanks for your prompt reply. i tried access the command line with mysql -u root -p with -u being the user(root) and -p(password) which is my root sql password.but i still get the error msg.what do you think would be wrong or what am i doing wrong?

  4. #4
    Initially, no password is set for the root account
    Plz, try using one of the following commands

    Code:
    mysql -u root
    Code:
    mysql -u username
    Code:
    mysql
    :and don't forget to change the password

  5. #5
    Moderator
    Good Guru
    Compunuts's Avatar
    Join Date
    May 2001
    Location
    California
    Posts
    3,935
    I don't know about Fedora but Ubuntu will take main sudoer's password and put it as mysql's root password. I thought fedora was more technically advanced in terms of security (or so some have claimed).
    LinuxVillage - The truely community run Linux/Floss forum !

    No IT BS !!

  6. #6

    Smile

    You can try the below method also
    use

    #/usr/sbin/mysqladmin -u root password 'new-password' and change the root user password for MySQL.

    Then restart the Mysql server.(service mysqld restart)

    #mysql -u root -p (hit enter)

    Mysql will ask for password...
    Enter the password and login...

    Even if you get the same error ... some other problem..

Similar Threads

  1. Mysql command line on network
    By omidkamangar in forum Windows - General Topics
    Replies: 3
    Last Post: 09-19-2008, 08:09 PM
  2. command line help
    By jan1024188 in forum Windows - General Topics
    Replies: 1
    Last Post: 01-10-2007, 09:48 AM
  3. Do I need a command line?
    By Kauno-Uolevi in forum Linux - General Topics
    Replies: 18
    Last Post: 08-17-2003, 03:47 PM
  4. Command line Printtool?
    By datamike in forum Linux - General Topics
    Replies: 2
    Last Post: 02-14-2002, 01:31 PM
  5. Using ftp from the command line.
    By chadm1967 in forum Linux - General Topics
    Replies: 5
    Last Post: 11-21-2001, 11:00 AM

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
  •