MySQL Tidbits Rumi, June 27, 2011 Allow Slave to connect master: C:\mysql>create user 'replica'@'192.168.0.110' identified by '<YOUR PASSWORD>'; NOTE: 192.168.0.110 which is the SLAVE machine‟s address. i. mysql>grant create,insert,select,update,delete on ejbca.* to 'replica'@'192.168.0.110'; Checking if Slave can connect to Master: C:\>mysql –u replica –h 192.168.0.100 –p C:\>Enter password: <YOUR VALUES> NOTE: If the mysql prompt opens then the Master machine can be accessed from the Slave machine. Related MySQL
Reset a MySQL root password for Debian July 14, 2016 Use the following steps to reset a MySQL root password by using the command line interface. Stop the MySQL service (Ubuntu and Debian) Run the following command: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: sudo /etc/init.d/mysqld stop Start MySQL without a password Run… Read More
MySQL: Show Users, Privileges and Passwords December 29, 2020 Show all MySQL users: mysql> SELECT user FROM mysql.user; List only unique user names: mysql> SELECT DISTINCT user FROM mysql.user; Show MySQL users and hosts they are allowed to connect from: mysql> SELECT user,host FROM mysql.user; Show MySQL users, their passwords and hosts: mysql> SELECT user,host,password FROM mysql.user; in MySQL… Read More
Install Mydumper Myloader on Centos 7 June 11, 2020July 4, 2020 If you want to execute logical backups using an alternative to mysqldump that works with parallel threads giving faster execution times mydumper is the correct tool. wget https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper-0.9.5-2.el7.x86_64.rpm In order to use mydumper and myloader you can use the following sample commands: For dumping/exporting database: mydumper -u <username> -p <password>… Read More