Following OpenSuse Wiki for LAMP install to Gecko Static Plasma.
And with help also from this forum ...
Have got to "mysql_secure_installation" but found the first stages different to the wiki.
Think I made a mistake and accepted the "advice" from MariaDB to do the following ...
Quote:
haven't set the root password yet, you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.
You already have your root account protected, so you can safely answer 'n'.
Switch to unix_socket authentication [Y/n] n
... skipping.
You already have your root account protected, so you can safely answer 'n'.
Change the root password? [Y/n] n
... skipping.
|
Remaining lines as per Wiki and got to end with ...
Quote:
MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'pmaUser'@localhost;
Query OK, 0 rows affected (0.005 sec)
MariaDB [(none)]> SELECT User, password FROM mysql.user;
+-------------+-------------------------------------------+
| User | Password |
+-------------+-------------------------------------------+
| mariadb.sys | |
| root | invalid |
| mysql | invalid |
| pmaUser | *6C8DC88838BA26F23FC09ED48861E966C911B4CB |
+-------------+-------------------------------------------+
4 rows in set (0.002 sec)
|
Now unable to login to phpMyAdmin with username "pmauser" and my root password.
Stopped and restarted mysql.
Ran "mysql_secure_installation" again.
This time changed password as per wiki.
Quote:
Password updated successfully!
Reloading privilege tables..
... Success!
|
Followed wiki stages to end.
Still refused login with access denied. Tried all lower case username as well.
mysqli_real_connect(): (HY000/1045): Access denied for user 'pmaUser'@'localhost' (using password: YES)
Checked Maria was restarted, still refused login via phpMyAdmin.
Got back into MariaDB from terminal using the new changed password and got this ...
Quote:
MariaDB [(none)]> SELECT User, password FROM mysql.user;
+-------------+-------------------------------------------+
| User | Password |
+-------------+-------------------------------------------+
| mariadb.sys | |
| root | *FD13D9FBB28354DE0F12ABB95F4E1DBC1AD1EDD1 |
| mysql | invalid |
| pmaUser | *6C8DC88838BA26F23FC09ED48861E966C911B4CB
|
Now stuck !
Have to go to day job now, back this evening.