I've set up an Ubuntu server and wanted to install MySQL 5.5. I've been following these MySQL documentation steps.
I have libaio dev
installed. Everything went fine until I ran
bin/mysqld_safe --user=mysql &
it outputs the following and keeps the prompt.
111130 12:57:44 mysqld_safe Logging to '/usr/local/mysql/data/host_name.err'.
111130 12:57:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
It runs into an issue and never returns to the shell. The output of mysqld_safe
is logging to /usr/local/mysql/data/host_name.err
.
I /usr/local/mysql/data/loft1551.host_name.err Row 29 Col 1 1:00 Ctrl-K H for help
111130 12:57:44 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
111130 12:57:44 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
111130 12:57:45 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
111130 12:57:45 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
111130 12:57:46 InnoDB: Waiting for the background threads to start
111130 12:57:47 InnoDB: 1.1.8 started; log sequence number 0
111130 12:57:48 [Note] Event Scheduler: Loaded 0 events
111130 12:57:48 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.17-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
there are already /tmp/mysql.sock in [mysqld]
and [client]
so i added under [mysqld]
datadir =/usr/local/mysql/data
but still getting the same issue What am i missing here ?
Thanks for reading this and helping out