This will helps when you forget MySQL root password and not able to access MySQL service on the server. Here are the steps to reset MySQL password : root@server [~] /etc/init.d/mysqld stop Now start MySQL server without password: root@server [~] mysqld_safe –skip-grant-tables & root@server [~] mysql After that you can get the mysql prompt then […]
See MoreTag: MySQL
How to replace MySQL with Percona Server Debian or Ubuntu in Vesta Control Panel
Replace MySQL with Percona Server Debian or Ubuntu You can safely replace MySQL with Percona Server without lossing any data. In order to do it, please follow the instructions bellow 1. Import Percona GPG key apt-key adv –keyserver keys.gnupg.net –recv-keys 1C4CBDCDCD2EFD2A 2. Add this to /etc/apt/sources.list, replacing VERSION with the name of your distribution: deb […]
See MoreHow to add remote MySQL database server in Vesta Control Panel
Add remote MySQL database server in Vesta Control Panel 1. It is assumed you already have your second server up and running. 2. On the first server run following command v-add-database-host mysql new-server.com root password 3. To make sure eveyrhing is in order, check database host list v-list-database-hosts
See More
You must be logged in to post a comment.