All open source applications use MySQL database. With the introduction of stored procedures in MySQL 5, it is getting widely adopted by Oracle developers and commercial organizations. If you are sysadmin, DBA, or developer, or someone who manages IT development, you should have good knowledge on MySQL database. A while back, I provided a list [...]
MySQL
By default, MySQL does not allow remote clients to connect to the MySQL database. If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter [...]
In this article, let us review how to install MySQL on CentOS using yum. Instead of searching and installing mysql and related packages one-by-one, it is better to install MySQL using yum groups. If you are interested in installing the full LAMP stack, refer to our earlier article on how to install/upgrade LAMP using yum. [...]
A while back we tried to customize unix prompt to look like Angelina Jolie. Oh boy, didn’t I fail miserably in that attempt? Well, that didn’t stop me from trying an extreme makeover for mysql> prompt. Let us face it. The following mysql> prompt is boring. Nobody wants to see it. Let us change the [...]
Question: How do I disable mysql history? I don’t want mysql to remember the previous commands that I typed from the mysql> prompt. This is important for me, as when I type some sql commands that contains passwords, I see the clear text password stored in the ~/.mysql_history, which I don’t want to happen. Answer: [...]
Forgot your MySQL root user password? Don’t worry. We are here for rescue. When you tried to login to root without entering a password, you may get ‘Access Denied’ message, as MySQL is expecting a password. This article explains how to recover mysql root password by setting a new MySQL password when you don’t remember [...]
Question: How do I change MySQL root Password? Answer: You can change MySQL root password using one of the following 3 methods. These methods can be used on both Windows and Unix Environment including Ubuntu, Debian, CentOS, Fedora, RedHat, Arch Linux, SUSE etc., Method 1. How to Change MySQL Root Password Using mysqladmin Command? You [...]
In all the 15 mysqladmin command-line examples below, tmppassword is used as the MySQL root user password. Please change this to your MySQL root password. 1. How to change the MySQL root user password? # mysqladmin -u root -ptmppassword password 'newpassword' # mysql -u root -pnewpassword Welcome to the MySQL monitor. Commands end with ; [...]
My name is Ramesh Natarajan. I will be posting instruction guides, how-to, troubleshooting tips and tricks on Linux, database, hardware, security and web. My focus is to write articles that will either teach you or help you resolve a problem. Read more about