Completely Uninstall MySQL Server

k_oudom · 10-05-2009, 08:11 PM

I try to uninstall MySQL server using rpm -e --nodeps mysql mysql-server and seen that it is not completely remove. When I install MySQL server again. The databases and root password still remain. May you tell me how to remove MySQL Server completely include databases and password? I'm using CentOS 5.3

One more thing, What is this command mean?

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

jhcaiced · 10-05-2009, 08:55 PM

Hi,
In order to completely remove the mysql program and data, you also need to
delete the /var/lib/mysql directory and it's contents.

Be aware that deleting the rpm package using --nodeps can break other
packages depending on it.

For the options of your command, I suggest you read "man mysql" all
options are explained there.

Best regards,

hexahost · 10-05-2009, 09:00 PM

Quote:

Originally Posted by k_oudom

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

mysqladmin is the program used to do administration of mysql Db from Linux shell. If you do not know this , what kind of task your are doing in a server ? Is your server is live and real ?

k_oudom · 10-05-2009, 09:37 PM

I'm working on a tutorial. I have seen this command line. Do you know what does it do?

kirukan · 10-05-2009, 11:34 PM

Simply you can assume what is that? (because there is a username and password, so it's a kind of security to protect your mysql). Don't expect the whole things from here to finish your assignment. Do the right search in google and prepare the assignment on yourself.

k_oudom · 10-05-2009, 11:39 PM

If you know you can tell me. That isn't easy to search the command line like this in google. It will be a lot of hits. If it is easy to learn linux, I wouldn't be here.

chrism01 · 10-06-2009, 12:01 AM

Perhaps you'd like to read this: http://linux.die.net/man/1/mysqladmin

kirukan · 10-06-2009, 12:13 AM

I have searched in google there is about 7450 links in this regards, the exact command that you have posted

Quote:

http://www.google.lk/#hl=en&source=h...f61471d47e3822

Quote:

I'm working on a tutorial. I have seen this command line. Do you know what does it do?

Even from any of link you can get the idea what does this command doing.

k_oudom · 10-06-2009, 03:00 AM

I ask here because I get error while configuring MySQL Server on CentOS 5.3

Code:

[root@server1 ~]# mysqladmin -u root password password123
[root@server1 ~]# mysqladmin -h server1.example.com -u root password password123
mysqladmin: connect to server at 'localhost' faild
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

When I try to telnet:

Code:

[root@server1 ~]# telnet server1.example.com
Trying 192.168.100.8...
telnet: connect to address 192.168.100.8: Connection refused
telnet: Unable to connect to remote host: Connection refused

Please don't try to lead me to read outside web pages. I already try to read a lot but It can't be help.

avijitp · 10-06-2009, 04:25 AM

Essence of GNU/Linux is to explore the power of openness if gives to you. It is always a pleasure to learn yourself and help others.

Code:

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

As described earlier, "mysqladmin" is a tool to connect to the mysql server and manage it. With the above command, you will be connected to the mysql server running in the host "server1.example.com" with user root and mysql password "yourrootsqlpassword".

Hope this helps.

k_oudom · 10-06-2009, 05:04 AM

Really? But why I have to connect to MySQL since I execute the command in the Server Machine.

avijitp · 10-06-2009, 05:07 AM

I believe you were asking an explanation of the command that you posted. When in the same server you can either use mysqladmin or mysql as you want.