Description:
Can not get MySQL 5.5 to install on Ubuntu 11.04 8/23/11
I have Windows 7 Ultimate x64. Using wubi I installed Ubuntu as a dual boot. It downloaded and installed ubuntu-11.04-desktop-amd64.iso.torrent (700M).
The installed Ubuntu system is
~$ uname -a
Linux ubuntu 2.6.38-11-generic-pae #48-Ubuntu SMP Fri Jul 29 20:51:21 UTC 2011 i686 i686 i386 GNU/Linux
Starting with a fresh install (MySql has not been installed on the Ubuntu install) I downloaded the MySQL-server-5.5.15-1.linux2.6.x86_64.rpm distribution. If I try to install or convert to .deb with alien I get the following error.
“MySQL-server-5.5.14-1.linux2.6.x86_64.rpm is for architecture amd64 ; the package cannot be built on this system.
I downloaded the mysql-5.5.15-linux2.6-x86_64.tar.gz and followed the following directions.
shell> groupadd mysql
shell> useradd -r -g mysql mysql
shell> cd /usr/local
shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
The mysql_install_db –user=mysql
fails with.--------------------------
root@ubuntu:/usr/local/mysql# scripts/mysql_install_db --user=mysql
./bin/my_print_defaults: 1: ELF####: not found
./bin/my_print_defaults: 1: #�fc##�: not found
./bin/my_print_defaults: 2: Syntax error: ")" unexpected
Neither host 'ubuntu' nor 'localhost' could be looked up with
./bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option
Using the --force option returned.------------------------------------
./bin/my_print_defaults: 1: ELF####: not found
./bin/my_print_defaults: 1: #�fc##�: not found
./bin/my_print_defaults: 2: Syntax error: ")" unexpected
Installing MySQL system tables...
./bin/mysqld: 1: Syntax error: ")" unexpected
Installation of system tables failed! Examine the logs in
./data for more information.
You can try to start the mysqld daemon with:
shell> ./bin/mysqld --skip-grant &
and use the command line tool ./bin/mysql
to connect to the mysql database and look at the grant tables:
shell> ./bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in ./data that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the ./bin/mysqlbug script!
Trying
root@ubuntu:/usr/local/mysql/bin# mysqld --skip-grant &
[1] 7939
root@ubuntu:/usr/local/mysql/bin# The program 'mysqld' can be found in the following packages:
* mysql-server-core-5.1
* mysql-cluster-server-5.1
Try: apt-get install <selected package>
-------------------------------------------------------------
I've read through the manual, tech boards and the MySQL email archives. Other people have had similar problems but I have found nothing that fixes it.
To sum up alien won't open the package, the mysql_install_db –user=mysql
script does not work and trying to manually run mysqld returns a response that implies the program is not installed.
I'm a sys admin simply trying to get MySQL 5.5 installed on Ubuntu 11.04. I have basic skills on unix but not an advanced degree in unix-geek. Are the MySQL and Ubuntu folks talking to each other trying to get this resolved? Is there a .deb release in the pipes or is Ubuntu planning to include MySQL5.5 in a 11.04 distribution? The mysqlbug script gives the same error as mysqld.
Thank you for any help.
Joe
How to repeat:
Just follow the steps in the description on Ubuntu 11.04.
Suggested fix:
Working distribution of MySQL for Ubutnu 11.04.