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
Recover MySQL root Password December 19, 2011 Step # 1 : Stop mysql service # /etc/init.d/mysql stop Output: Stopping MySQL database server: mysqld. Step # 2: Start to MySQL server w/o password: # mysqld_safe –skip-grant-tables & Output:[1] 5988 Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[6025]: started Step # 3: Connect to mysql server using mysql client:… Read More
Install Percona XtraDB Cluster for MySQL 5.7 on Debian 8 February 18, 2019 First of all, why we choose three nodes and not only two? In any cluster, the number of nodes should be odd, so in the case of disconnection of a node, we assume that the highest group of servers has the fresh data, and should be replicated to the down node… 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