How to Allow MySQL Client to Connect to Remote MySQL server Rumi, December 19, 2011 By default, MySQL does not allow remote clients to connect to the MySQL database. If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h… Continue Reading
Recover MySQL root Password Rumi, 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:… Continue Reading
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… Continue Reading
MySQL Replication by MySQL Rumi, June 27, 2011 The easiest and most straightforward method for setting up replication is to use new master and slave servers. You can also use this method if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your… Continue Reading
MySQL Replication Rumi, June 27, 2011 MySQL is the relational database system of choice for open sourcers. Replication is the process of replicating data from one MySQL database server (the master) into another (the slave). We’ll go into why you would want to replicate a MySQL database in another article. MySQL Replication Using the master-slave configuration… Continue Reading