mySQL: The error log says this. (And mysql will not start)

[kingoslo]

Hello there.

I do:

$ ps -ef | grep mysql
kingoslo  9188  9125  0 13:57 pts/0    00:00:00 grep --color=auto mysql
$ sudo service mysql start

And it doesn't start.

I checked error log. This is repeated over and over hundreds if not throusands of times:

111218 14:17:44  InnoDB: Starting shutdown...
111218 14:17:49  InnoDB: Shutdown completed; log sequence number 0 44233
111218 14:17:49 [Note] /usr/sbin/mysqld: Shutdown complete

111218 14:18:14 [Note] Plugin 'FEDERATED' is disabled.
111218 14:18:14  InnoDB: Initializing buffer pool, size = 8.0M
111218 14:18:14  InnoDB: Completed initialization of buffer pool
111218 14:18:14  InnoDB: Started; log sequence number 0 44233
111218 14:18:14 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
111218 14:18:14 [ERROR] Do you already have another mysqld server running on port: 3306 ?
111218 14:18:14 [ERROR] Aborting

At the beginning of the log it says:

111211  3:42:27 [Note] Plugin 'FEDERATED' is disabled.
111211  3:42:27  InnoDB: Initializing buffer pool, size = 8.0M
111211  3:42:27  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
111211  3:42:27  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
111211  3:42:27  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...
111211  3:42:27  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: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
111211  3:42:28  InnoDB: Started; log sequence number 0 0
111211  3:42:28  InnoDB: Starting shutdown...
111211  3:42:33  InnoDB: Shutdown completed; log sequence number 0 44233
111211  3:42:33 [Note] Plugin 'FEDERATED' is disabled.
111211  3:42:33  InnoDB: Initializing buffer pool, size = 8.0M
111211  3:42:33  InnoDB: Completed initialization of buffer pool
111211  3:42:33  InnoDB: Started; log sequence number 0 44233
111211  3:42:33  InnoDB: Starting shutdown...
111211  3:42:38  InnoDB: Shutdown completed; log sequence number 0 44233
111211  3:42:38 [Note] Plugin 'FEDERATED' is disabled.
111211  3:42:38  InnoDB: Initializing buffer pool, size = 8.0M
111211  3:42:38  InnoDB: Completed initialization of buffer pool
111211  3:42:39  InnoDB: Started; log sequence number 0 44233
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
111211  3:42:39 [ERROR] Aborting

What is your reckoning?

Kind regards,
Marius

[scathefire]

Is this a fresh install? Did you do the mysqladmin portion of setting the root password and all that?

mysqladmin -u root password 'passwordyouwant'

[kingoslo]

Is this a fresh install? Did you do the mysqladmin portion of setting the root password and all that?

mysqladmin -u root password 'passwordyouwant'

Thanks man, but that failed. What do you reckon:

$ sudo mysqladmin -u root password abc123abc123
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Kind regards,
Marius

[scathefire]

Maybe this will help you...

[ubuntu] MySQL Startup Failing/Hanging in 10.04 - Ubuntu Forums

[kingoslo]

Maybe this will help you...

[ubuntu] MySQL Startup Failing/Hanging in 10.04 - Ubuntu Forums

Thanks for the reply, the problem is I cannot complete step 4 because as root I do:

$ mysql -u root --password=myrootpassword
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Same error as before, basically.

What do you reckon is going on?

Thanks man.M

[scathefire]

Check under /etc/, look for my.cnf (maybe under /etc/mysql? or just /etc/ not sure).

Look for bind-address, make sure its set correctly.

[kingoslo]

Check under /etc/, look for my.cnf (maybe under /etc/mysql? or just /etc/ not sure).

Look for bind-address, make sure its set correctly.

The above fixed my problem.

Thanks man!

Kind regards,
Marius