(Solved) Mysql (MariaDB 10.+) login without password or with some random string.

-

 Even if you successfully set the mysql root password, mysql(MariaDb 10.+) allows you to login without any password or with any random string. 

Solution : the default mariaDB installations plugins like  'console' or 'unix_socket' allows us to login without password. Try following commands to solve the issue. 

mysql -u root -p 
use mysql;
SELECT host, user, password, plugin FROM mysql.user LIMIT 0,1;

---------------------------------------------------------------------------------
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
UPDATE mysql.user SET plugin = '' WHERE user = 'root' AND host = 'localhost';
FLUSH PRIVILEGES;


Comments

Post a Comment

Popular posts from this blog

ACTION_FAILED:OU_INVALID: Solution for GoogleApps bulk user upload issue, username@domainname.com:ACTION_FAILED:OU_INVALID. This error is because you have not specified the Org Unit Path properly.

-
To upload bulk users to GoogleApps, you will require a following required fileds, other fields are optional:-               First Name               Last Name               Email Address               Password               Org Unit Path What is 'Org Unit Path'? This field was not their earlier. This is the path to place users in an organizational unit. For example if your domain has different organization unit like , staff, students, guest etc.. then the Org Unit Path would be just :  /
Read more

Email Notification in Koha! How to configure Email Notification in Koha 20.11 with postfix?

-
Image
Here is the steps to configuring Koha 20.11 & postfix for sending notices/slips through email. 1. First install postfix             #sudo apt-get update             #sudo apt-get install postfix          Click on OK.    Tab and select No configuration. 2.  Copy the configuration file     #  cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf 3. Install the other required packages.     #apt-get install libsasl2-2     #apt-get install libsasl2-modules     #apt-get install ca-certificates 4.  Open the following file and add few lines.     # vim /etc/postfix/main.cf and add the following lines at the bottom of the page and save the file.     relayhost = [smtp.gmail.com]:587     smtp_sasl_auth_enable = yes     smtp_sasl_password_...
Read more

Moodle OAuth 2. This account is pending email confirmation! Solved

-
Image
If you happen to come across this ' This account is pending email confirmation' message while using Google OAuth2 in Moodle. Try these following solutions: Solution 1. First login to you Moodle and Admin. Go to Site Administration --> Server--> oAuth 2 Services go to setting. Make sure the Require email verification is NOT checked. Solution 2: Login to Moodle database and delete the particular user #mysql -uroot -p\ mysql> use moodledb; mysql> SELECT * FROM mdl_auth_oauth2_linked_login WHERE email='sjamso@moodle.edu.bt'; mysql>D ELETE FROM mdl_auth_oauth2_linked_login WHERE email='sjamso@moodle.edu.bt';
Read more