Guest User

Untitled

a guest
Jan 14th, 2019
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. uname -or
  2. 2.6.32-754.6.3.el6.x86_64 GNU/Linux
  3.  
  4. uname -a
  5. Linux vps-xxx-xxx.example.com 2.6.32-754.6.3.el6.x86_64 #1 SMP Tue Oct 9 17:27:49 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
  6.  
  7. cat /etc/*elease`
  8. CentOS release 6.10 (Final)
  9. CentOS release 6.10 (Final)
  10. CentOS release 6.10 (Final)
  11.  
  12. SELECT VERSION();
  13. 5.5.61
  14.  
  15. select User,Host from mysql.user;
  16.  
  17. +----------------+-----------+
  18. | User | Host |
  19. +----------------+-----------+
  20. | admin_test | % |
  21. | admin_test | localhost |
  22. | root | localhost |
  23. | roundcube | localhost |
  24. +----------------+-----------+
  25.  
  26. 1. service mysqld stop
  27. Stopping mysqld: [OK]
  28.  
  29. 2. mysqld_safe --skip-grant-tables &
  30. [1] 713
  31. [root@vps-xxx-xxx ~]# 190113 14:44:01 mysqld_safe Logging to '/var/log/mysqld.lo g'.
  32. 190113 14:44:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/ mysql
  33.  
  34. 3. mysql
  35. Welcome to the MySQL monitor. Commands end with ; or g.
  36. Your MySQL connection id is 1
  37. Server version: 5.5.61 MySQL Community Server (GPL) by Remi
  38.  
  39. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
  40.  
  41. Oracle is a registered trademark of Oracle Corporation and/or its
  42. affiliates. Other names may be trademarks of their respective
  43. owners.
  44.  
  45. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  46.  
  47. 4. UPDATE mysql.user SET Password=PASSWORD('123456qwerty7890') WHERE User='admin_test';
  48.  
  49. Query OK, 0 rows affected (0.01 sec)
  50. Rows matched: 2 Changed: 0 Warnings: 0
  51.  
  52. 5. FLUSH PRIVILEGES;
  53. Query OK, 0 rows affected (0.00 sec)
  54.  
  55. 6. exit;
  56. Bye
  57.  
  58. 7. mysqladmin -u root -p shutdown
  59. Enter password:
  60.  
  61. 190113 14:48:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ende d
  62. [1]+ Done mysqld_safe --skip-grant-tables
  63.  
  64. 8. service mysqld start
  65. Starting mysqld: [ OK ]
  66.  
  67. xx.xxx.xxx.xxx/phpmyadmin
Add Comment
Please, Sign In to add comment