Problems trying to install MariaDB
by dmchess from LinuxQuestions.org on (#53EGZ)
I am having trouble with a MariaDB install. I have blown away a previous install of Linux Mint and replaced it with a 19.2-64. I installed the cinnamon version, but then added the Mate desktop. MariaDB did install, but it never asked me to set the root password. This is on a i7-8700 cpu. I would really prefer to get Mariadb working, but if I have to I can try to get mysql working. My comments will be in italics bold, my commands will be in bold.
I have used the following website to reset the password as refrence:
https://www.digitalocean.com/communi...-root-password
terry@cloudedleopard:~$ mysql --version
mysql Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
terry@cloudedleopard:~$ sudo systemctl stop mariadb
terry@cloudedleopard:~$ sudo mysqld_safe --skip-grant-tables --skip-networking &
[1] 2028
terry@cloudedleopard:~$ 200513 18:19:23 mysqld_safe Logging to syslog.
200513 18:19:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
At this point the command prompt just halts, so I fired up another one and continued on with the instructions
mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
First I flush the privileges
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
Then I try to alter the password
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypass';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'root'@'localhost' IDENTIFIED BY 'mypass'' at line 1
According to the web site, that was supposed to work with this version. But just in case I try the command that is supposed to work on older versions.
MariaDB [(none)]> set password for 'root'@'localhost' = password(mypass');
ERROR 1131 (42000): You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings
Finally, I run the third option:
MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('mypass') where User = 'root';
Query OK, 0 rows affected (0.03 sec)
Rows matched: 1 Changed: 0 Warnings: 0
I have tried, but can not stop the temporary MariaDB, finally I reboot the whole system.
MariaDB [(none)]> exit
Bye
terry@cloudedleopard:~$ sudo kill `/var/run/mariadb/mariadb.pid`
bash: /var/run/mariadb/mariadb.pid: No such file or directory
[sudo] password for terry:
Usage:
kill [options] <pid> [...]
Options:
<pid> [...] send signal to every <pid> listed
-<signal>, -s, --signal <signal>
specify the <signal> to be sent
-l, --list=[<signal>] list all signal names, or convert one to a name
-L, --table list all signal names in a nice table
-h, --help display this help and exit
-V, --version output version information and exit
For more details see kill(1).
After rebooting, I try to log in:
terry@cloudedleopard:~$ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Any suggestions???
I have used the following website to reset the password as refrence:
https://www.digitalocean.com/communi...-root-password
terry@cloudedleopard:~$ mysql --version
mysql Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
terry@cloudedleopard:~$ sudo systemctl stop mariadb
terry@cloudedleopard:~$ sudo mysqld_safe --skip-grant-tables --skip-networking &
[1] 2028
terry@cloudedleopard:~$ 200513 18:19:23 mysqld_safe Logging to syslog.
200513 18:19:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
At this point the command prompt just halts, so I fired up another one and continued on with the instructions
mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
First I flush the privileges
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
Then I try to alter the password
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypass';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'root'@'localhost' IDENTIFIED BY 'mypass'' at line 1
According to the web site, that was supposed to work with this version. But just in case I try the command that is supposed to work on older versions.
MariaDB [(none)]> set password for 'root'@'localhost' = password(mypass');
ERROR 1131 (42000): You are using MariaDB as an anonymous user and anonymous users are not allowed to modify user settings
Finally, I run the third option:
MariaDB [(none)]> UPDATE mysql.user SET authentication_string = PASSWORD('mypass') where User = 'root';
Query OK, 0 rows affected (0.03 sec)
Rows matched: 1 Changed: 0 Warnings: 0
I have tried, but can not stop the temporary MariaDB, finally I reboot the whole system.
MariaDB [(none)]> exit
Bye
terry@cloudedleopard:~$ sudo kill `/var/run/mariadb/mariadb.pid`
bash: /var/run/mariadb/mariadb.pid: No such file or directory
[sudo] password for terry:
Usage:
kill [options] <pid> [...]
Options:
<pid> [...] send signal to every <pid> listed
-<signal>, -s, --signal <signal>
specify the <signal> to be sent
-l, --list=[<signal>] list all signal names, or convert one to a name
-L, --table list all signal names in a nice table
-h, --help display this help and exit
-V, --version output version information and exit
For more details see kill(1).
After rebooting, I try to log in:
terry@cloudedleopard:~$ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
Any suggestions???