To quickly view your status try the following commands sudo /etc/init.d/mysql status To stop or start issue one of the
Category: Unix/Linux
MySQL – Dump all databases
If you ever need to backup all your MySQL databases at the same time use the following command mysqldump -u
MySQL – restore databases (command line – Linux)
Methods of restoring MySQL databases To restore a MySQL database you can use one of the following methods after creating
Linux – run a sh file
Problem You have a script “myscripttorun.sh” and cannot get it run as a script Solution Open a terminal SU as
CentOS – install desktop on CentOS 7
Problem You finished installing CentOS7 and its minimal and drops you at the console prompt but no desktop. Solution Ensure
CentOS – install updates
Problem You finished installing CentOS7 and need to update it. Solution To run your updates simply type in the command
CentOS – How to configure static ip address on CentOS 7
Problem You just finished an install of CentOS 7 and need it to be networked with a static address Solution
MySQL – Retrieve “lost” MySQL user name and password (Unix/Linux)
Problem You are trying to log into MySQL but you have the wrong credentials and need admin/root access Solution To