I was trying to setup MySQL server on Ubuntu after package installation but faced following error during mysql_secure_installation,so I followed the below method to fix it. Error: … Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. Solution: Open another terminal and login…
Issue / Error:- [[email protected] ~]# service mysqld restart Redirecting to /bin/systemctl restart mysqld.service Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details. MySQL error logs:- [[email protected] ~]# cat /var/lib/mysql/server.the-d2.com.err 2019-10-20 10:12:56 1220654356911872 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-10-20 10:12:56 1220656458905792 [Note]…
Login to MySQL root or limited user, then use the database:- use the-d2.com_db; MariaDB > select * from core_config_data where path like ‘%base%url%’; +———–+———+———-+—————————–+——————————————+ | config_id | scope | scope_id | path | value | +———–+———+———-+—————————–+——————————————+ | 52 | default | 0 | web/unsecure/base_url | https://www.the-d2.com/ | | 53 | default | 0 | web/unsecure/base_link_url | {{unsecure_base_url}} | | 54 | default | 0 | web/unsecure/base_skin_url | {{unsecure_base_url}}skin/ | |…
– name: Install MySQL hosts: test123 become: true become_user: root gather_facts: true tasks: – name: “Installing Repo & Packages” yum: name=http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm – name: Install MySQL 5.7 yum: pkg={{ item }} with_items: – mysql-community-server – mysql-community-client
SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘new_password’); flush privileges;