Related Articles
MySQL Master-Master Replication
Create MySQL user CREATE USER ‘droaming’@’localhost’ IDENTIFIED BY ‘DroamG.123’; CREATE USER ‘droaming’@’%’ IDENTIFIED BY ‘DroamG.123’; Drop Mysql User DROP USER ‘droaming’@’localhost’; DROP USER ‘droaming’@’%’; Create Mysql Database and grant permission CREATE DATABASE droaming; GRANT ALL ON droaming.* TO ‘droaming’@’localhost’; View MySQL users SELECT User, Host, Password FROM mysql.user; MySQL Master-Master Replication SERVER 01 [mysqld] datadir=/var/lib/mysql […]
Useful MySQL Commands
Database with size SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Create a database. mysql> create database [databasename]; List all databases on the server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the […]
Setup wordpress on VPS in Sinhala (සිංහල)
අද මම කියල දෙන්නේ datacenter.lk එකෙන් අපි අරගත්ත VPS එකේ wordpress install කරන්නේ කොහොමද කියල. web server එක setup කරනහැටි බලන්න අපේ youtube channel එකහරි කලින් පොස්ට් එක හරි බලන්න. මුලින්ම අපි setup කරපු domain එකේ document root එකට ගිහින් wordpress download කරගෙන extract කරගන්නවා මේ විදියට [root@test web]# cd /opt/web/ [root@test web]# ls [root@test […]