Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: problem mysql

  1. #1
    Join Date
    Apr 2012
    Beans
    35

    Unhappy problem mysql


    hello ...


    PHP Code:
    h313@h313:~$ mysql -u root -p
    Enter password

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

    The problem appear even during install phpmyadminHe thinks when entering phpmyadmin panel
    Tired and I'm looking for a solution




  2. #2
    Join Date
    May 2006
    Location
    Milwaukee,WI
    Beans
    6,280
    Distro
    Xubuntu 14.04 Trusty Tahr

    Re: problem mysql

    did you forget the password when you setup mysql? here's a guide for resetting your root mysql password
    http://www.cmdln.org/2008/02/09/rese...root-password/

  3. #3
    Join Date
    Apr 2012
    Beans
    35

    Re: problem mysql

    also problem
    h313@h313:~$ mysql -u root -pEnter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)a

    and images top I'm not forget password

  4. #4
    Join Date
    Jul 2013
    Beans
    2

    Re: problem mysql

    Should you use:
    sudo mysql -u root -p

  5. #5
    Join Date
    Apr 2012
    Beans
    35

    Re: problem mysql

    h313@h313:~$ sudo mysql -u root -p
    Enter password:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
    Last edited by hussiniraq; July 13th, 2013 at 05:54 PM.

  6. #6
    Join Date
    Apr 2012
    Beans
    35

    Re: problem mysql

    /var/run/mysqld/ not found

  7. #7
    Join Date
    Apr 2012
    Beans
    7,256

    Re: problem mysql

    It sounds like you don't actually have a mysql server instance running on that machine - you can check with

    Code:
    service mysql status
    
    sudo netstat -nlp | grep mysql
    
    dpkg -l | grep mysql
    (the last one checks whether you have mysql-server installed)

  8. #8
    Join Date
    Nov 2007
    Location
    London, England
    Beans
    7,699

    Re: problem mysql

    "Access denied for user 'root'@'localhost' (using password: YES)" will not happen unless he connects to the mysql daemon. If it's not running you get "Can't connect to local MySQL server".

    My guess is that you have the wrong password.
    This is a way to reset the password.
    http://dev.mysql.com/doc/refman/5.0/...rmissions.html

    If you are sure you have it right, then perhaps you should consider that it might have been guessed and changed by someone else.

  9. #9
    Join Date
    Apr 2012
    Beans
    35

    Re: problem mysql

    h313@h313:~$ service mysql status
    mysql stop/waiting



    h313@h313:~$ sudo netstat -nlp | grep mysql
    [sudo] password for h313:
    h313@h313:~$ dpkg -l | grep mysql
    ii libdbd-mysql-perl 4.020-1build2 Perl5 database interface to the MySQL database
    ii libmysqlclient18 5.5.31-0ubuntu0.12.04.2 MySQL database client library
    ii libmysqlclient18:i386 5.5.31-0ubuntu0.12.04.2 MySQL database client library
    ii libqt4-sql-mysql 4:4.8.1-0ubuntu4.4 Qt 4 MySQL database driver
    ii libqt4-sql-mysql:i386 4:4.8.1-0ubuntu4.4 Qt 4 MySQL database driver
    ii mysql-client 5.5.31-0ubuntu0.12.04.2 MySQL database client (metapackage depending on the latest version)
    ii mysql-client-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database client binaries
    ii mysql-client-core-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database core client binaries
    ii mysql-common 5.5.31-0ubuntu0.12.04.2 MySQL database common files, e.g. /etc/mysql/my.cnf
    ii mysql-server 5.5.31-0ubuntu0.12.04.2 MySQL database server (metapackage depending on the latest version)
    ii mysql-server-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database server binaries and system database setup
    ii mysql-server-core-5.5 5.5.31-0ubuntu0.12.04.2 MySQL database server binaries
    ii php5-mysql 5.3.10-1ubuntu3.6 MySQL module for php5
    h313@h313:~$


    top

  10. #10
    Join Date
    Apr 2012
    Beans
    7,256

    Re: problem mysql

    Try starting it - post back if you get errors

    Code:
    sudo service mysql start

Page 1 of 2 12 LastLast

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
  •