LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 01-07-2011, 06:21 PM   #1
chetanmadaan
Member
 
Registered: Sep 2009
Posts: 30

Rep: Reputation: 15
two mysql's hosted on machine.


Hi guys -

Operating system CentOS Linux 5.5
Kernel and CPU Linux 2.6.18-194.11.3.el5 on x86_64
hosted with sonic.net

we have a strange setup for one of our clients... the problem is that the machine was orginal setup with mysql and php and when they build out the website...

the other guys installed lampp and setup the website into the htdocs folder into the lampp directory.

the problem is that when we SSH. we get into a different mysql

and the website is running on it's own mysql setup which was originally setup with lampp.

now, we want to setup another database and it won't let us do it... just because we don't have the root username and password for the mysql of lampp.

bottomline, we have two mysql's running on the same matchine.
1. we can ssh into.
2. the website runs on.

is there any way we can reset the passsword of the phpmyadmin of the lampp root user.
Thanks
Chetan
 
Old 01-08-2011, 08:53 PM   #2
chetanmadaan
Member
 
Registered: Sep 2009
Posts: 30

Original Poster
Rep: Reputation: 15
anyone???? please
 
Old 01-09-2011, 04:39 AM   #3
routers
Member
 
Registered: Aug 2005
Location: Malaysia - KULMY / CNXTH
Distribution: Slackware, Fedora, FreeBSD, Sun O/S 5.10, CentOS
Posts: 774
Blog Entries: 6

Rep: Reputation: 75
you can change mysql root password as long as you have system root password
i wonder what is otherguy mean, as far as i know LAMP cannot be install as user access
must be that person having root access for the system

btw this the command to reset mysql root
remind you as root not user

------------------start mysql

mysqld_safe --skip-grant-tables &


login to mysql w/o pw

mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit

--------------

then use new pass
 
Old 01-10-2011, 01:11 AM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
With MySQL, as with other RDBMSes, you may have multiple 'schemas' owned by different people within one physical database install.
https://secure.wikimedia.org/wikiped...atabase_schema
A db schema is often (loosely) referred to as a database, which can be confusing. You can usually tell by context which is actually meant. Note that each db schema can be owned/managed by a different user and will be invisible to all other users except the DBA.
Unfortunately, in MySQL they chose to use the name 'root' for the DBA user role, which tends to lead to even more confusion on *nix systems.
 
Old 01-10-2011, 03:35 AM   #5
chetanmadaan
Member
 
Registered: Sep 2009
Posts: 30

Original Poster
Rep: Reputation: 15
thanks guys but no thanks... like i said... there are two different mysql's installed on the server.

one running on the site and second is the one i can ssh into.

so, i can't change the password as i am not sshing into the one i need to be.

i do have the root username ans password.

thanks
 
Old 01-11-2011, 04:05 AM   #6
chetanmadaan
Member
 
Registered: Sep 2009
Posts: 30

Original Poster
Rep: Reputation: 15
anyone?
 
Old 01-11-2011, 06:52 AM   #7
routers
Member
 
Registered: Aug 2005
Location: Malaysia - KULMY / CNXTH
Distribution: Slackware, Fedora, FreeBSD, Sun O/S 5.10, CentOS
Posts: 774
Blog Entries: 6

Rep: Reputation: 75
can you follow my command guide as it

[root@server ~]#
Quote:
netstat -tanp | grep 3306
and paste/show the output what you get from that mechine
include the [root@bla bla]
 
Old 01-14-2011, 10:31 AM   #8
resetreset
Senior Member
 
Registered: Mar 2008
Location: Cyberspace
Distribution: Dynebolic, Ubuntu 10.10
Posts: 1,340

Rep: Reputation: 62
I think both mysql's will listen on the same port for connections, unless there's a way to change that in a conf file or something.
 
Old 01-14-2011, 10:44 AM   #9
routers
Member
 
Registered: Aug 2005
Location: Malaysia - KULMY / CNXTH
Distribution: Slackware, Fedora, FreeBSD, Sun O/S 5.10, CentOS
Posts: 774
Blog Entries: 6

Rep: Reputation: 75
Quote:
Originally Posted by resetreset View Post
I think both mysql's will listen on the same port for connections, unless there's a way to change that in a conf file or something.
i think Impossible

Last edited by routers; 01-14-2011 at 10:46 AM. Reason: edit
 
Old 01-14-2011, 12:09 PM   #10
jmc1987
Member
 
Registered: Sep 2009
Location: Oklahoma
Distribution: Debian, CentOS, windows 7
Posts: 872

Rep: Reputation: 112Reputation: 112
Yea if you haven't edited your mysql config file you may have both using same port. But the real question is. Why do you have 2 mysql servers running on one machine? Your wasting ram and processor in my opinion. 1 Mysql server you can put many data bases to it. Well good luck with it
 
1 members found this post helpful.
  


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



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Accessing Website Being Hosted on Virtual Machine Hi_This_is_Dev Linux - Server 10 09-02-2010 06:44 PM
Asian files hosted on windows machine not displaing TRaven Ubuntu 7 10-26-2007 03:56 PM
Change name of mysql's binary logs Ratclaws Linux - Software 0 09-07-2005 02:53 PM
mysql's password() peteABK Linux - Software 3 10-24-2003 12:57 AM
How to view the web site hosted on win2k server which is a client machine? gogo Linux - Networking 10 10-19-2002 11:48 PM


All times are GMT -5. The time now is 09:05 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration