sudo /etc/init.d/mysql stop

sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

sudo mysql -u root

>FLUSH PRIVILEGES;

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

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

>FLUSH PRIVILEGES;

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start

sudo mkdir /var/log/mysql

sudo chmod -R 777 /var/log/mysql

sudo chown -R mysql:mysql /var/lib/mysql

sudo chmod -R 777 /var/lib/mysql

sudo /etc/init.d/mysql stop

sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

sudo mysql -u root < /home/dz/dz.sql

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start

>FLUSH PRIVILEGES;

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

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

>FLUSH PRIVILEGES;