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!
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.
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
This is some of my notes i keep, does it help ? ( Fedora Core 1 notes mysql setup )
[root@localhost root]# /usr/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
031120 1:01:10 /usr/libexec/mysqld: Shutdown Complete
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr ; /usr/bin/safe_mysqld &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; run-all-tests
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
Support MySQL by buying support/licenses at https://order.mysql.com
[root@localhost root]# /etc/rc.d/init.d/mysqld start
Starting MySQL: [ OK ]
Test MySQL now
[root@localhost root]# /usr/bin/mysql -u root -p >> < enter password when asked >
it should show you the databases. [ mysql ] and [ test ]
[root@localhost bin]# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
| Database |
| mysql |
| test |
2 rows in set (0.01 sec)
Last edited by tommytomato; 06-04-2004 at 04:16 AM.
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.
ok I cant find a 'hostname'.err file but here is the log for mysql
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
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 at http://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?