SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: mySQL get root

  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2007
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mySQL get root

    Sorry no one responded earlier. I have a dedicated server, In mySQL but I am missing the root user and I need a root user with full rights in mySQL.

    I have a root server user and use SSH

    I keep getting an error


    GRANT ALL PRIVILEGES ON * . * TO 'admin'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

    MySQL said: Documentation
    #1045 - Access denied for user 'admin'@'localhost' (using password: YES)


    I was trying to make admin able to grant rights because no users have the grant option


    Its kinda a catch 22.. I need to create a user have full rights but no user can create this user... Can anyone help


    How do I create a root user that has full rights



    Thank You

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,708
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    See reset root password in the manual. it will help you start mysql without the root user existing. you can then add one manually.

  3. #3
    SitePoint Member
    Join Date
    Jan 2013
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Did you try to log in to the mysql console as root? by default there should be no root password. So, just type on SSH:

    mysql -u root -p (and press ENTER where you will be asked for password)


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
  •