Find the answer to your Linux question:
Results 1 to 10 of 10
ok, ive installed apache,mysql,and phpmyadmin on my computer, the website works when i make hp file and stuff like that, but when i go to use phpmyadmin and log in ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie thesimplecreator's Avatar
    Join Date
    Jun 2007
    Location
    washington , USA
    Posts
    229

    newb having problems with databases


    ok, ive installed apache,mysql,and phpmyadmin on my computer,
    the website works when i make hp file and stuff like that,

    but when i go to use phpmyadmin and log in as admin with the password being blank, it says i dont have permission to create databases.

    and when i try to log on as my normal account, it doesnt let me log on and it says:
    #1045 - Access denied for user 'cody'@'localhost' (using password: YES)

    im a newb at mysql,servers,etc.
    so im not sure what i should do or how i should do it so it will let me add databases.
    Microsoft isn't evil, they just make really crappy operating systems.
    Linus Torvalds

    Personal and politically centrist blog.--->
    http://www.deathnerd.com

  2. #2
    Linux Engineer jledhead's Avatar
    Join Date
    Oct 2004
    Location
    North Carolina
    Posts
    1,077
    if this is all a default install have you tried root and no password?

  3. #3
    Linux Newbie thesimplecreator's Avatar
    Join Date
    Jun 2007
    Location
    washington , USA
    Posts
    229
    yes this is a default install,
    when i try root with no pass i get
    #1045 - Access denied for user 'root'@'localhost' (using password: NO)
    on phpmyadmin
    Microsoft isn't evil, they just make really crappy operating systems.
    Linus Torvalds

    Personal and politically centrist blog.--->
    http://www.deathnerd.com

  4. #4
    Linux Engineer jledhead's Avatar
    Join Date
    Oct 2004
    Location
    North Carolina
    Posts
    1,077
    what distro and how did you install all of this?

  5. #5
    Linux Newbie thesimplecreator's Avatar
    Join Date
    Jun 2007
    Location
    washington , USA
    Posts
    229
    im on ubuntu 8.04 hardy
    i installed all of it through synaptic package manager
    Microsoft isn't evil, they just make really crappy operating systems.
    Linus Torvalds

    Personal and politically centrist blog.--->
    http://www.deathnerd.com

  6. #6
    Linux Engineer jledhead's Avatar
    Join Date
    Oct 2004
    Location
    North Carolina
    Posts
    1,077
    and you install mysql-server?

    here is something to try from an ubuntu guide
    Code:
    Set mysql root password
    
    Before accessing the database by console you need to type:
    
    mysql -u root
    
    At the mysql console type:
    
    mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
    taken from here
    https://help.ubuntu.com/community/ApacheMySQLPHP

    report back how it goes

  7. #7
    Linux Newbie thesimplecreator's Avatar
    Join Date
    Jun 2007
    Location
    washington , USA
    Posts
    229
    ok... this is what i got when i entered it in
    Code:
    cody@ubuntu:~$ mysql -u root
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    cody@ubuntu:~$ mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 69
    Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpassword');
    ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
    mysql>
    Microsoft isn't evil, they just make really crappy operating systems.
    Linus Torvalds

    Personal and politically centrist blog.--->
    http://www.deathnerd.com

  8. #8
    Linux Newbie
    Join Date
    Apr 2008
    Location
    India
    Posts
    170
    Hey
    I feel that your mysql password is wrong .. try changing the mysql password
    use the following links
    Resetting a forgotten MySQL root password
    David's Dairy: Reset mysql root password when lost
    and try login now....
    Regards
    David Anand
    -->Success is the list of failures ...!!!

  9. #9
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    3,601
    When you installed mysql-server it will have asked you for a root password
    "I used to be with it, then they changed what it was.
    Now what was it isn't it, and what is it is weird and scary to me.
    It'll happen to you too."

    Grandpa Simpson



    The Fifth Continent

  10. #10
    Linux Newbie thesimplecreator's Avatar
    Join Date
    Jun 2007
    Location
    washington , USA
    Posts
    229
    ohh. well i reinstalled ubuntu becuase of an unrelated problem yesterday morning, so thanx for the help ill keep it in mind when i reinstall apache and mysql
    Microsoft isn't evil, they just make really crappy operating systems.
    Linus Torvalds

    Personal and politically centrist blog.--->
    http://www.deathnerd.com

Posting Permissions

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