Knowledge base category
MySQL
69 practical guides in MySQL.
How to Run MySQL Query in phpMyAdmin
In this documentation, we can check how to run MySQL query in phpMyAdmin. 1) Login to cPanel account. 2) Click the icon ‘phpMyAdmin’ from the section ‘DATABASES’.
MySQLPostgreSQL Availability
PostgreSQL is not available on our Web Hosting Packages. PostgreSQL can be installed on VPS or Dedicated Servers.
MySQLDatabase Management in Plesk
In this documentation, we can check how to manage database in Plesk control panel. 1) Login to Plesk admin panel. 2) Click the ‘Domains’ button.
MySQLAccess denied for user da_admin – MySQL error in DirectAdmin
Sometimes we will get the following MySQL errors in DirectAdmin.
MySQLMySQL Management in Direct Admin
In this documentation, we can check how to manage MySQL in Direct Admin. 1) Login to Direct Admin panel.
MySQLHow can I start and stop mysql?
The standard start/stop scripts are located in /etc/init.d or for older linux versions /etc/rc.d/init.d.
MySQLHow to recover the mysql root password?
Steps to recover the mysql root password 1.Stop the mysql service # service mysql stop (or) # /etc/rc.d/init.d/mysql stop 2.Start mysql in safe mode by using command...
MySQLBack Up and Test a MySQL Database from the Command Line
Back up MySQL privately with mysqldump, understand InnoDB consistency limits and test recovery in a separate database before touching production.
MySQLHow can I increase MySQL max connections?
Edit the file /etc/my.cnf The file should look like this: [mysqld] set-variable = max_connections=500 Increase 500 to the number you desire.
MySQLDisable MySQL Strict mode
To disable strict mode on cpanel servers in mysql 5.6 edit /etc/my.cnf add in under [mysqld]...
MySQLInstalling LAMP Stack on Ubuntu / Debian
Before installing the LAMP stack, you need to update the repositories and software packages. To do this, please execute the following command
MySQLPHPMyAdmin shows every database when logging in as a user
If phpmyadmin shows all the databases on a server when it should only show the users databases do the following: First be sure a MySQL root password is set.