Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sudo apt-get install mysql-server
- mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrappe
- ERROR 1698 (28000): Access denied for user 'root'@'localhost'
- sudo service mysql stop
- sudo mysqld_safe --skip-grant-tables &
- mysql -u root
- mysql> use mysql;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> update user set password=PASSWORD("password") where User='root';
- ERROR 1054 (42S22): Unknown column 'password' in 'field list'
- mysql> desc user;
- +------------------------+-----------------------------------+------+-----+-----------------------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +------------------------+-----------------------------------+------+-----+-----------------------+-------+
- | Host | char(60) | NO | PRI | | |
- | User | char(32) | NO | PRI | | |
- | Select_priv | enum('N','Y') | NO | | N | |
- | Insert_priv | enum('N','Y') | NO | | N | |
- | Update_priv | enum('N','Y') | NO | | N | |
- | Delete_priv | enum('N','Y') | NO | | N | |
- | Create_priv | enum('N','Y') | NO | | N | |
- | Drop_priv | enum('N','Y') | NO | | N | |
- | Reload_priv | enum('N','Y') | NO | | N | |
- | Shutdown_priv | enum('N','Y') | NO | | N | |
- | Process_priv | enum('N','Y') | NO | | N | |
- | File_priv | enum('N','Y') | NO | | N | |
- | Grant_priv | enum('N','Y') | NO | | N | |
- | References_priv | enum('N','Y') | NO | | N | |
- | Index_priv | enum('N','Y') | NO | | N | |
- | Alter_priv | enum('N','Y') | NO | | N | |
- | Show_db_priv | enum('N','Y') | NO | | N | |
- | Super_priv | enum('N','Y') | NO | | N | |
- | Create_tmp_table_priv | enum('N','Y') | NO | | N | |
- | Lock_tables_priv | enum('N','Y') | NO | | N | |
- | Execute_priv | enum('N','Y') | NO | | N | |
- | Repl_slave_priv | enum('N','Y') | NO | | N | |
- | Repl_client_priv | enum('N','Y') | NO | | N | |
- | Create_view_priv | enum('N','Y') | NO | | N | |
- | Show_view_priv | enum('N','Y') | NO | | N | |
- | Create_routine_priv | enum('N','Y') | NO | | N | |
- | Alter_routine_priv | enum('N','Y') | NO | | N | |
- | Create_user_priv | enum('N','Y') | NO | | N | |
- | Event_priv | enum('N','Y') | NO | | N | |
- | Trigger_priv | enum('N','Y') | NO | | N | |
- | Create_tablespace_priv | enum('N','Y') | NO | | N | |
- | ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
- | ssl_cipher | blob | NO | | NULL | |
- | x509_issuer | blob | NO | | NULL | |
- | x509_subject | blob | NO | | NULL | |
- | max_questions | int(11) unsigned | NO | | 0 | |
- | max_updates | int(11) unsigned | NO | | 0 | |
- | max_connections | int(11) unsigned | NO | | 0 | |
- | max_user_connections | int(11) unsigned | NO | | 0 | |
- | plugin | char(64) | NO | | mysql_native_password | |
- | authentication_string | text | YES | | NULL | |
- | password_expired | enum('N','Y') | NO | | N | |
- | password_last_changed | timestamp | YES | | NULL | |
- | password_lifetime | smallint(5) unsigned | YES | | NULL | |
- | account_locked | enum('N','Y') | NO | | N | |
- +------------------------+-----------------------------------+------+-----+-----------------------+-------+
- 45 rows in set (0.00 sec)
- sudo dpkg-reconfigure mysql-server
- cat /etc/mysql/debian.cnf
- user = debian-sys-maint
- password = xxxxGx0fSQxxGa
- sudo service mysql stop
- sudo mysqld_safe --skip-grant-tables &
- mysql -u root
- mysql> use mysql;
- mysql> update user set password=PASSWORD("NewPasswd") where User='root';
- mysql> flush privileges;
- mysql> quit
- sudo service mysql stop
- sudo service mysql start
- mysql -u root -p
Add Comment
Please, Sign In to add comment