3a) Secure MariaDB
By default there is no password for MySQL instant and you need to run the below command to set the root password for security reason but we have set the password in our previous step, so we can bypass for setting root password.
Run mysql_secure_installation command to adjust other settings to make your database more secure such as removing anonymous users, Disallow root login remotely, Remove test database and access & Reload privilege tables.
I strongly recommend user to secure MySQL installation using mysql_secure_installation.
[MariaDB Secure installation] $ sudo mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! Enter current password for root (enter for none): Enter Your Current Password OK, successfully used password, moving on... Set root password? [Y/n] n ... skipping. Remove anonymous users? [Y/n] y ... Success! Disallow root login remotely? [Y/n] y ... Success! Remove test database and access to it? [Y/n] y - Dropping test database... ... Success! - Removing privileges on test database... ... Success! Reload privilege tables now? [Y/n] y ... Success! Cleaning up... All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB!
You mentioned Mongo in the beginning of the article. Do you know the best way to get 3.x mongo in opensuse 42.1 and on?
@2daygeek, here is the error message. It is inside my first post,
Error
MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
@Guru,
Can you please make the below change
from ($cfg[‘Servers’][$i][‘auth_type’] = ‘config’;) to $cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
Also make sure you should update correct password.
$cfg[‘Servers’][$i][‘password’] = ‘password’;
Hi,
I am getting error on my phpMyAdmin online GUI webpage. When I go to
http://localhost/phpMyAdmin, I am getting this error below.
Error
MySQL said: Documentation
Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
The only change I did is that I upgraded from MariaDB 5.5 to MariaDB 10.1 just recently. I tried root username and password. It did not work. I tried every step. I even changed the root allow without password inside config.inc.php file. It did not work. Any suggestions as to How can I fix this. I am using opensuse 13.1 and mariadb 10.1
Any help is much appreciated. Thanks in advance 🙂 I have been trying to solve this for 3 weeks.
@Guru,
Before upgrade this was work fine? if so, Can I have the screenshot of error message.
A good tutorial, thank you very much!
@Darko,
Glad to hear, welcome.
Hi
Great article helped a lot.
One point you can just use yast and put ‘lamp’ in the file search bar, much quicker.
Ralph
@Allen,
Yes, I thought to include pattern method too. Will add your suggestion.
Thanks a lot for this really helpful guide!
Just a little comment: At the end of 4., you want to open localhost/phpinfo.php (the file that was just created), not localhost/index.php
@Peter,
Its typo, we have modified. Thank you so much.
The forum is a brhgiter place thanks to your posts. Thanks!
@Rosie,
Welcome.