Guest User

Untitled

a guest
Aug 1st, 2018
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.16 KB | None | 0 0
  1. sudo apt-get install mysql-server
  2.  
  3. mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrappe
  4.  
  5. ERROR 1698 (28000): Access denied for user 'root'@'localhost'
  6.  
  7. sudo service mysql stop
  8. sudo mysqld_safe --skip-grant-tables &
  9. mysql -u root
  10.  
  11. mysql> use mysql;
  12. Reading table information for completion of table and column names
  13. You can turn off this feature to get a quicker startup with -A
  14.  
  15. Database changed
  16. mysql> update user set password=PASSWORD("password") where User='root';
  17. ERROR 1054 (42S22): Unknown column 'password' in 'field list'
  18. mysql> desc user;
  19. +------------------------+-----------------------------------+------+-----+-----------------------+-------+
  20. | Field | Type | Null | Key | Default | Extra |
  21. +------------------------+-----------------------------------+------+-----+-----------------------+-------+
  22. | Host | char(60) | NO | PRI | | |
  23. | User | char(32) | NO | PRI | | |
  24. | Select_priv | enum('N','Y') | NO | | N | |
  25. | Insert_priv | enum('N','Y') | NO | | N | |
  26. | Update_priv | enum('N','Y') | NO | | N | |
  27. | Delete_priv | enum('N','Y') | NO | | N | |
  28. | Create_priv | enum('N','Y') | NO | | N | |
  29. | Drop_priv | enum('N','Y') | NO | | N | |
  30. | Reload_priv | enum('N','Y') | NO | | N | |
  31. | Shutdown_priv | enum('N','Y') | NO | | N | |
  32. | Process_priv | enum('N','Y') | NO | | N | |
  33. | File_priv | enum('N','Y') | NO | | N | |
  34. | Grant_priv | enum('N','Y') | NO | | N | |
  35. | References_priv | enum('N','Y') | NO | | N | |
  36. | Index_priv | enum('N','Y') | NO | | N | |
  37. | Alter_priv | enum('N','Y') | NO | | N | |
  38. | Show_db_priv | enum('N','Y') | NO | | N | |
  39. | Super_priv | enum('N','Y') | NO | | N | |
  40. | Create_tmp_table_priv | enum('N','Y') | NO | | N | |
  41. | Lock_tables_priv | enum('N','Y') | NO | | N | |
  42. | Execute_priv | enum('N','Y') | NO | | N | |
  43. | Repl_slave_priv | enum('N','Y') | NO | | N | |
  44. | Repl_client_priv | enum('N','Y') | NO | | N | |
  45. | Create_view_priv | enum('N','Y') | NO | | N | |
  46. | Show_view_priv | enum('N','Y') | NO | | N | |
  47. | Create_routine_priv | enum('N','Y') | NO | | N | |
  48. | Alter_routine_priv | enum('N','Y') | NO | | N | |
  49. | Create_user_priv | enum('N','Y') | NO | | N | |
  50. | Event_priv | enum('N','Y') | NO | | N | |
  51. | Trigger_priv | enum('N','Y') | NO | | N | |
  52. | Create_tablespace_priv | enum('N','Y') | NO | | N | |
  53. | ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
  54. | ssl_cipher | blob | NO | | NULL | |
  55. | x509_issuer | blob | NO | | NULL | |
  56. | x509_subject | blob | NO | | NULL | |
  57. | max_questions | int(11) unsigned | NO | | 0 | |
  58. | max_updates | int(11) unsigned | NO | | 0 | |
  59. | max_connections | int(11) unsigned | NO | | 0 | |
  60. | max_user_connections | int(11) unsigned | NO | | 0 | |
  61. | plugin | char(64) | NO | | mysql_native_password | |
  62. | authentication_string | text | YES | | NULL | |
  63. | password_expired | enum('N','Y') | NO | | N | |
  64. | password_last_changed | timestamp | YES | | NULL | |
  65. | password_lifetime | smallint(5) unsigned | YES | | NULL | |
  66. | account_locked | enum('N','Y') | NO | | N | |
  67. +------------------------+-----------------------------------+------+-----+-----------------------+-------+
  68. 45 rows in set (0.00 sec)
  69.  
  70. sudo dpkg-reconfigure mysql-server
  71.  
  72. cat /etc/mysql/debian.cnf
  73.  
  74. user = debian-sys-maint
  75. password = xxxxGx0fSQxxGa
  76.  
  77. sudo service mysql stop
  78. sudo mysqld_safe --skip-grant-tables &
  79. mysql -u root
  80.  
  81. mysql> use mysql;
  82. mysql> update user set password=PASSWORD("NewPasswd") where User='root';
  83. mysql> flush privileges;
  84. mysql> quit
  85.  
  86. sudo service mysql stop
  87. sudo service mysql start
  88. mysql -u root -p
Add Comment
Please, Sign In to add comment