Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
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.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
mysql is confusing as hell... when i run /usr/sbin/mysqld it says "do you have mysqld server running on port: xxxxxx" and then aborts. so i think that means its already running but i dont see it when i do a ps. anyways, if it is already running how do i change the password for root. I installed using rpm and where is the default directory?
You can find out if it is starting when your machine boots by, (as root), typing ntsysv at your console, then scrolling down to mysqld. If it is not selected, you can select it to start it every time your machine boots.
A good way to see if mysql is running on Red Hat is to type 'service --status-all | grep mysql' to find it. You can start and stop the service by 'service stop mysqld' or 'service start mysqld'.
Here is a link that will tell you all about setting up your password on mysql, and a couple of ways of doing it:
Limit root and non-essential access. Change the default (empty) root password. Delete any non-localhost 'root' users, and any 'blank' users.
mysqladmin -u root password new_password
mysql -u root --password=new_password
mysql> use mysql;
mysql> delete from user where host = '%';
mysql> delete from user where user = '';
mysql> delete from db where user = '';
mysql> select user, host from user;
If you see any 'root' users other than root@localhost, delete them -- e.g.
mysql> delete from user where user = 'root' and host='myhost.com'
Flush the privileges, and you're done.
Mysql is selected, but in "ntsysv" but everytime i issue the command "mysql -u root mysql" it comes back w/ "mysql: unrecongized command". I used that link to set up mysql but its so confusing. I was lost after 2nd chapter.
Ok, if you know its started, type 'mysql -u root' to login, (if you have not set your password). You will then be able to set your password and security stuff up. There is a post in this thread already that would be helpful there.
first, thanks for the quick replies
but thats what my problem is...it seems like its running but when i issue the command "mysql -u root" it says "command not found" i found a lot of help online and i am going through each one to see which one makes sense the most.
I would do a search to find the path to where it was installed...since you installed using an rpm. I would recommend running updatedb as root, then slocate mysql. Once that is done, you may have the path you need to login to mysql, and you can add that to your system or user environment variable $PATH.
there are entries for mysql in /var/lib/mysql, /usr/sbin/mysqld and /usr/share/mysql. Is this normal? and when i do "printenv $PATH", this command doesn't return anything. I put those directories in my .bash_profile under $PATH, but it still doesn't work
Last edited by dilberim82; 02-14-2004 at 10:35 PM.
To see your path, type 'echo $PATH'. If you update your path, you have to logout and login to have it take effect, or you can export your path.
Those entries for the locations of mysql do not seem normal, I would expect that you would have a /usr/bin/mysql so that all users can use it. /var/lib/mysql/ is the directory where your databases are stored... /usr/share/mysql/ is a directory with some character set and language stuff. I would try to type /usr/sbin/mysql or /sbin/mysql and see what that does for you. If it is the correct command, you should see an error saying that Access is denied.
Where did you get the rpms that you installed from? Can you post the hyperlink? I would like to take a look.
I went ahead and downloaded the binary version and did it over again and i just put in /usr/local/mysql/bin. It works now, but i still cannot access it through apache, but i think i'll figure it out. Thanks a lot Josh. I'll ask you more questions if i have any.