Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ sudo /etc/init.d/mysql stop
- * Stopping MySQL database server mysqld [ OK ]
- [1]- Exit 1 sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking
- [2]+ Exit 1 sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking
- reg@regDesktopHome:~$ sudo mysqld --skip-grant-tables &
- [1] 13651
- reg@regDesktopHome:~$ 140627 19:02:02 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
- reg@regDesktopHome:~$ mysql -u root mysql
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- reg@regDesktopHome:~$ sudo mysql -u root mysql
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- [1]+ Exit 1 sudo mysqld --skip-grant-tables
- $ ps ax| grep mysql
- 16515 ? Ssl 0:00 /usr/sbin/mysqld
- 16551 pts/23 S+ 0:00 grep --color=auto mysql
- reg@regDesktopHome:~/semios/v3upgrade$ sudo kill -9 16515
- reg@regDesktopHome:~/semios/v3upgrade$ ps ax| grep mysql
- 16678 ? Ssl 0:00 /usr/sbin/mysqld
- 16715 pts/23 S+ 0:00 grep --color=auto mysql
- reg@regDesktopHome:~/semios/v3upgrade$ mysql -u root
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql -u root -p
- apt-cache policy mysql-server
- Installed: 5.5.37-0ubuntu0.12.04.1
- sudo dpkg-reconfigure mysql-server-*.*
- mysql -u root -p
- sudo service mysql stop
- sudo killall -9 mysqld
- sudo mysqld_safe --skip-grant-tables --skip-networking &
- mysql -u root
- FLUSH PRIVILEGES;
- UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
- UPDATE mysql.user SET authentication_string=PASSWORD('newpwd') WHERE User='root';
- FLUSH PRIVILEGES;
- exit
- sudo killall mysqld_safe && sudo service mysql start
- mysql -u root -p
- Enter password: newpass
- mysql>
- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';
- UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
- FLUSH PRIVILEGES;
- mysqld_safe --init-file=/home/me/mysql-init &
- sudo service mysql stop
- sudo mysqld_safe &
- sudo mysql -u root
- ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
- FLUSH PRIVILEGES;
- QUIT;
- sudo killall mysqld
- sudo service mysql start
- sudo mysql -u root -p
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement