Linux - NewbieThis 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
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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
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
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.
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
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.