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 |…

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,…

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…

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…