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,571
    When you installed mysql-server it will have asked you for a root password
    What do we want?
    Time machines!

    When do we want 'em?
    Doesn't really matter does it!?


    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
  •