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

anyone???? please

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

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.

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

anyone?

can you follow my command guide as it

[root@server ~]# and paste/show the output what you get from that mechine
include the [root@bla bla]

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

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