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.

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.

Remember to edit the conf file of phpmyadmin so that it fits your needs.

also remember that, with phpmyadmin, in the DB "mysql", you must use the option "password" for the password field, when you set it for root user.
(Used md5 which didn't work, got the same problems after that)

As I had this probleem too, mysqld was running several times at once, so I had to stop all of them, before restarting it.

On Mysql.com there is a tutorial on how to reset the root password, by the way....

I must be doing something wrong here....I dont understand the fact that the server will start and say OK when there is no password...but if there is i will do /etc/init.d/mysqld start and it says FAILED

yeah its only running once......it funny that when I do /etc/init.d/mysqld restart it will tell me that it shut down ok, but it will say failed on the start end....but when in fact it still starts. Whats that about?

I dont have a problem loggin into mysql from mysql -u r oot -p
the problem that I have is when I try /etc/init.d/mysqld start it pauses for about 10 seconds and then says failed. but what peculiar about it is it must be running because my website works that I am working on...its phpnuke web portal with mysql database. so what I am really asking is why does it say failed when I start the server when it seems to be running?

It depends on how you are trying to start it. If you are using InnoDB, you would get an error message if your config is wrong. Look in the /mysql/data directory at the 'hostname'.err file. That will tell you why it is failing. Secondly, don't try to run it from etc/init.d unless you are wanting it to start at boot. You should only start the server from the /mysql/bin folder. If you want to start the mysql server from boot, let me know and I will post the instructions to do so.

040604 23:39:39 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 athttp://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

it refers to the innodb like you mentioned.....so what do I do from here?