How To Install MySQL – MariaDB on CentOS 7

Install MySQL / MariaDB Installing MariaDB is as simple as running just one command: # yum -y install mariadb-server mariadb And then start MySQL, now MariaDB: # systemctl start mariadb Be sure that MySQL/MariaDB starts at boot: # systemctl enable mariadb To check the status of MySQL/MariaDB: # systemctl status mariadb To top MySQL/MariaDB: # […]

Read More

Reset maria DB password on Plesk

Is it mysql or maria? # service mysqld status Redirecting to /bin/systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) ]# systemctl status mariadb.service mariadb.service – MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled) Active: active (running) since Mon 2015-10-05 21:03:57 EST; 3min 30s ago Process: 26953 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, […]

Read More

Install mtop on centos 6

Install RPMForge on CentOS 6 # wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm # rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm Import RPMForge Repository Key in CentOS 6 # wget http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt # rpm –import RPM-GPG-KEY.dag.txt Install Mtop in CentOS 6 Once you’ve installed and enabled RPMForge repository, let’s install MTOP using following YUM command. # yum install mtop To start Mtop program, you need […]

Read More

Install Apache, Mysql and PHP on Ubuntu 14.04

How to install Apache, MySQL and PHP on Ubuntu 14.04 Update # sudo apt-get update Apache # sudo apt-get install apache2 Install MySQL # sudo apt-get install mysql-server php5-mysql # sudo mysql_install_db # mysql_secure_installation Install PHP # sudo apt-get install php5 libapache2-mod-php5 php5-mcrypt Restart Server # sudo /etc/init.d/apache2 restart Check Apache Open a web browser […]

Read More

Failed to issue method call: Unit mysqld.service failed to load: No such file or directory.

# mysql –version mysql Ver 15.1 Distrib 5.5.37-MariaDB, for Linux (x86_64) using readline 5.1 I ran the mysql command on the system – I received the error message shown below: # mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I checked to see if the mysqld service was running […]

Read More

Mysql optimization

From MySQL Large Configuration. MySQL Large Original # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer_size = 256M max_allowed_packet = 1M table_open_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size= 16M # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 […]

Read More