Tag Archives: MySQL

How to reset root user password in MySQL 5.7+

Was too busy and haven’t written anything for quite a while! Anyway, here is how to reset the root user password in MySQL 5.7 and later in a nutshell! service mysql stop mkdir -p /var/run/mysqld chown mysql:mysql /var/run/mysqld mysqld_safe –skip-grant-tables … Continue reading

Posted in Linux, MySQL | Tagged , , , , | Leave a comment

How to stop mysql from starting up automatically in Ubuntu Desktop

MySQL uses a different mechanism other than apache2, so you can simply comment the three lines inside “/etc/init/mysql.conf” Change this: start on (net-device-up and local-filesystems and runlevel [2345]) stop on runlevel [016] to this: #start on (net-device-up # and local-filesystems … Continue reading

Posted in Ubuntu | Tagged , , , , , | Leave a comment

Setting up MySQL Server and GUI Client tools on Ubuntu Gutsy

Type the following in the terminal: “sudo apt-get install mysql-server mysql-query-browser mysql-admin” (Note: You can read the manual of any command by invoking the “man” command and providing the command’s name as its parameter, e.g. “man apt-get” I don’t like … Continue reading

Tagged | Leave a comment