January 30, 2019, 7:08 am

The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, DELETE etc. In general, Mysql Grant All Privileges ensures that one user has access to one or more databases and/or table. How...

January 29, 2019, 4:49 pm

ABOUT MySQL MySQL is an open source relational database management system. MySQL is a component of the LAMP web application software stack, which is an acronym for Linux, Apache, MySQL, PHP. A web application using MySQL database have to authenticate via a mysql user and password who has sufficient privileges on that particular...

May 2, 2016, 6:40 pm

Firstly, by default MySQL is installed only listening to localhost. It’s closed so that it won’t listen to your public IPs externally. This tutorial works both for Ubuntu, Debian and CentOS. To grant mysql remote access, we need to first of all open the MySQL to listen to external connections, and then, enable...

May 2, 2016, 5:19 pm

To recover or reset MySQL root password in Ubuntu, you should simply follow some steps. This process may vary according to the operating system. Ubuntu offerts a possibility to restore the root password via dpkg, which is a native package management system. Recovering the database root access: reset MySQL root password...

May 2, 2016, 4:29 pm

To install MySQL in Ubuntu, need to have root access to an Ubuntu server. This tutorial applies either to a dedicated server and a cheap vps hosting server. The first step is to login by SSH into your server. First of all, we have to update all the packages of the server sudo apt-get update sudo apt-get...