OS - RHEL 5.5 I have root access to the server. I have also created a user 'mysql' on the seerver. The mysql db was preinstalled for us and user mysql was created as a root user of the db.
Here is what happens If I login to the machine with user mysql, I can access the mysql shell. But when I log in as root, I cannot access the mysql shell even when I do 'su mysql'
Question - What is the reason behind this behavior? Isn't logging in with 'mysql' and changing to user 'mysql' the same things?