LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
LinkBack Search this Thread
Old 10-05-2009, 08:11 PM   #1
k_oudom
Member
 
Registered: Aug 2009
Posts: 277

Rep: Reputation: 30
Completely Uninstall MySQL Server


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

Last edited by k_oudom; 10-05-2009 at 08:15 PM.
 
Old 10-05-2009, 08:55 PM   #2
jhcaiced
Member
 
Registered: Mar 2009
Distribution: CentOS - Ubuntu - Debian
Posts: 83

Rep: Reputation: 27
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,
 
Old 10-05-2009, 09:00 PM   #3
hexahost
LQ Newbie
 
Registered: Oct 2008
Location: Chennai - INDIA
Distribution: CentOS
Posts: 10

Rep: Reputation: 0
Quote:
Originally Posted by k_oudom View Post
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 ?
 
Old 10-05-2009, 09:37 PM   #4
k_oudom
Member
 
Registered: Aug 2009
Posts: 277

Original Poster
Rep: Reputation: 30
I'm working on a tutorial. I have seen this command line. Do you know what does it do?
 
Old 10-05-2009, 11:34 PM   #5
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,180

Rep: Reputation: 113Reputation: 113
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.
 
Old 10-05-2009, 11:39 PM   #6
k_oudom
Member
 
Registered: Aug 2009
Posts: 277

Original Poster
Rep: Reputation: 30
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.
 
Old 10-06-2009, 12:01 AM   #7
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5
Posts: 16,086

Rep: Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993Reputation: 1993
Perhaps you'd like to read this: http://linux.die.net/man/1/mysqladmin
 
Old 10-06-2009, 12:13 AM   #8
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,180

Rep: Reputation: 113Reputation: 113
I have searched in google there is about 7450 links in this regards, the exact command that you have posted
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.
 
Old 10-06-2009, 03:00 AM   #9
k_oudom
Member
 
Registered: Aug 2009
Posts: 277

Original Poster
Rep: Reputation: 30
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.
 
Old 10-06-2009, 04:25 AM   #10
avijitp
Member
 
Registered: May 2005
Location: India
Distribution: FC11, Debian/Ubuntu, RHEL, Solaris, AIX, HP-UX
Posts: 161

Rep: Reputation: 32
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.
 
Old 10-06-2009, 05:04 AM   #11
k_oudom
Member
 
Registered: Aug 2009
Posts: 277

Original Poster
Rep: Reputation: 30
Really? But why I have to connect to MySQL since I execute the command in the Server Machine.
 
0 members found this post helpful.
Old 10-06-2009, 05:07 AM   #12
avijitp
Member
 
Registered: May 2005
Location: India
Distribution: FC11, Debian/Ubuntu, RHEL, Solaris, AIX, HP-UX
Posts: 161

Rep: Reputation: 32
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Uninstall MYSQL completely then reinstall....help! phill79 Linux - Newbie 2 08-31-2008 01:46 PM
How To Completely Uninstall Quake 4? carlosinfl Linux - Games 7 03-20-2008 11:32 AM
mysql - uninstall completely yogaboy Linux - Software 4 12-27-2006 05:13 PM
how to completely uninstall a program royeo Linux - Newbie 1 09-20-2006 09:19 PM
how do I completely uninstall IE ddaas General 17 01-20-2005 06:21 PM


All times are GMT -5. The time now is 08:35 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration