systemctl stop mariadb – Rodrigo Silva e Silva

[root@srvweb ~]# mysql --version
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

1 2	[root@srvweb ~]# mysql --version mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

[root@srvweb ~]# ps -ef |grep mysql
root      2102  3048  0 17:14 pts/0    00:00:00 grep --color=auto mysql
mysql     3683     1  0 Oct12 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
mysql     3894  3683  0 Oct12 ?        07:39:57 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib mysql/mysql.sock

1

2

3

4

[root@srvweb ~]# ps -ef |grep mysql

root 2102 3048 0 17:14 pts/0 00:00:00 grep --color=auto mysql

mysql 3683 1 0 Oct12 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --basedir=/usr

mysql 3894 3683 0 Oct12 ? 07:39:57 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib mysql/mysql.sock

[root@srvweb ~]# systemctl stop mariadb

1	[root@srvweb ~]# systemctl stop mariadb

[root@srvweb ~]# mysqld_safe --skip-grant-tables --skip-networking &
[1] 3190
[root@srvweb ~]# 191202 17:14:45 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
191202 17:14:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

1

2

3

4

[root@srvweb ~]# mysqld_safe --skip-grant-tables --skip-networking &

[1] 3190

[root@srvweb ~]# 191202 17:14:45 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

191202 17:14:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

[root@srvweb ~]# mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

1

2

3

4

5

6

7

8

[root@srvweb ~]# mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 2

Server version: 5.5.60-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.02 sec)

1 2	MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('PASSWORD');
Query OK, 0 rows affected (0.00 sec)

1 2	MariaDB [(none)]> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('PASSWORD'); Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('PASSWORD') WHERE User = 'root' AND Host = 'localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

1

2

3

MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('PASSWORD') WHERE User = 'root' AND Host = 'localhost';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [(none)]> CREATE USER 'teste'@'localhost' IDENTIFIED BY 'password';

ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

1

2

3

MariaDB [(none)]> CREATE USER 'teste'@'localhost' IDENTIFIED BY 'password';

ERROR 1290 (HY000): The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

[root@srvweb ~]# mysqladmin shutdown
[1]+  Done                    mysqld_safe --skip-grant-tables --skip-networking

1 2	[root@srvweb ~]# mysqladmin shutdown [1]+ Done mysqld_safe --skip-grant-tables --skip-networking

systemctl start mariadb

systemctl start mysql

1

2

3

systemctl start mariadb

systemctl start mysql

Tag: systemctl stop mariadb

Reset password Mysql 5.5 | MariaDB 5.5