Archive for the ‘SQL’ Category


Sometime I have this problem: Access denied for user ‚root’@’localhost’ (using password: NO) I have described solution below:

  • Start the mysql client process using this command (sudo /etc/init.d/mysql start):
    mysql -u root
  • Execute this command to be able to change any password:
    FLUSH PRIVILEGES;

    Then reset/update your password:

    SET PASSWORD FOR root@'localhost' = PASSWORD('password');

    If we have a mysql root account that can connect from everywhere, you should also do:

    UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root';

    Alternate Method:

    USE mysql UPDATE user SET Password = PASSWORD('newpassword') WHERE Host = 'localhost' AND User = 'root';

    And if you have a root account that can access from everywhere:

    USE mysql UPDATE user SET Password = PASSWORD('newpassword') WHERE Host = '%' AND User = 'root';
  • Or faster:

USE mysql;
FLUSH PRIVILEGES;
UPDATE user SET Password = PASSWORD(‚dupa’) WHERE Host = ‚%’ AND User = ‚root’;

 

Then stop/restart the mysqld process:

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start
or
sudo /etc/init.d/mysql restart

Copying data between tables:

 

INSERT INTO table SELECT * FROM base2.table;


Copying data between tables including fields list:

 

INSTER INTO client (client_id, word) SELECT 4, word FROM client WHERE client_id = 3;