7 articles mysql

How to monitor Mysql or Maria Database with command line on Unix

How to monitor Mysql or Maria Database with command line on Unix Connect Database Server mysql –host=ServerNameOrIP -uUserName -pPassword Select Database for uses use Database Command for show database process show processlist; For example. MariaDB [CSTSEG_STG]> show processlist; +——+————+———————-+————+———+——+——-+——————+———-+ | Id | User | Host | db | Command | Time | State | Info |…

How to grant remote access for MySQL DB anb Maria DB

How to grant remote access for MySQL DB anb Maria DB ssh to server login to mysql server via command “mysql -u xxxx -p” Run this command–> GRANT ALL ON *.* to [email protected]’%‘ IDENTIFIED BY ‘Passwd Userxx‘; completed   Noted: % –> IP Address Client, If set % is mean any ip For more information: https://support.hostatom.com/knowledgebase.php?action=displayarticle&id=117

How to Back Up MySQL Databases From The Command Line

How to Back Up MySQL Databases From The Command Line Creating A Backup The mysqldump command is used to create textfile “dumps” of databases managed by MySQL. These dumps are just files with all the SQL commands needed to recreate the database from scratch. The process is quick and easy. If you want to back…

how to Create new webserv

Basic Software, set hostname –> hostname xxxxxx install web server apache2 –sudo apt-get install apache2 install php –>sudo apt-get install php install mysql –sudo apt-get install mysql-server install phpmyadmin –>sudo apt-get install phpmyadmin set apache ssl –> https://www.digitalocean.com/community/tutorials/how-to-create-a-ssl-certificate-on-apache-for-ubuntu-14-04   Additional, install Private cloud (owncloud) –>https://www.digitalocean.com/community/tutorials/how-to-install-and-configure-owncloud-on-ubuntu-16-04 install FTP Server visual memory –>https://www.digitalocean.com/community/tutorials/how-to-add-swap-on-ubuntu-14-04

MySQL Tuner for fixed server error

for fixed error in mysql please see as below, mysql-server-keeps-stopping-unexpectedly mysql memory usage ubuntu MySQL is mostly configured in /etc/mysql/my.cnf on Ubuntu / Debian.  The final adjustments key_buffer              = 8M max_connections = 30 query_cache_size        = 8M query_cache_limit = 512K thread_stack = 128K