IS my mysql database table Innodb or Mysiam

MariaDB [(none)]> show table status from admin_geek01; +-----------------------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-----------------------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-----------------+----------+----------------+---------+ | 2qGr3sjm_commentmeta | MyISAM | 10 | Dynamic | 0 | 0 | 2704…

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: # systemctl stop mariadb Check the…

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, status=0/SUCCESS) Process: 26922 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n…

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 to connect to your MySQL…

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 and navigate to http://IPADDRESS. You…