[NTLUG:Discuss] MySQL help needed urgently

[Stephen Davidson]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Greetings.

This is for a contract, so will pay.  I am trying to install MySQL on my
Linux box, but it won't successfully install & configure.  Output;

sda64:~ # rpm -Uvh /home/steve/Downloads/mysql/MySQL-*
Preparing...                ###########################################
[100%]
   1:MySQL-shared-compat    ###########################################
[ 20%]
   2:MySQL-client-community ###########################################
[ 40%]
   3:MySQL-devel-community  ###########################################
[ 60%]
   4:MySQL-server-community ###########################################
[ 80%]
mysql                     0:off  1:off  2:on   3:on   4:on   5:on   6:off
ERROR: 1004  Can't create file '/tmp/root/#sql316b_1_0.frm' (errno: 13)
090220 10:15:52 [ERROR] Aborting

090220 10:15:52 [Warning] Forcing shutdown of 2 plugins
090220 10:15:52 [Note] /usr/sbin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/var/lib/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/sbin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com/.  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 /usr/bin/mysqlbug script!

Starting MySQL.                                                       done
Giving mysqld 2 seconds to start
   5:MySQL-shared-community ###########################################
[100%]
sda64:~ # cat /var/lib/mysql/
mysql/      mysql.sock  sda64.err   sda64.pid   test/
sda64:~ # cat /var/lib/mysql/sda64.err
090220 10:15:52 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
/usr/sbin/mysqld: Can't create/write to file '/tmp/root/ibXDNX2s'
(Errcode: 13)
090220 10:15:52  InnoDB: Error: unable to create temporary file; errno: 13
090220 10:15:52 [ERROR] Plugin 'InnoDB' init function returned error.
090220 10:15:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
090220 10:15:52 [Note] Event Scheduler: Loaded 0 events
090220 10:15:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.31-community'  socket: '/var/lib/mysql/mysql.sock'  port:
3306  MySQL Community Server (GPL)
sda64:~ # ls -l /tmp/ro
root/      rough.txt
sda64:~ # ls -l /tmp/root/
total 112
- -rw------- 1 root root 23486 Nov 27 10:24 492ec9a815662
- -rw------- 1 root root 23486 Jan 22 11:38 4978aef913787
drwx------ 2 root root  4096 Apr 27  2008 gconfd-root
drwx------ 2 root root  4096 Jun  3  2008 kde-root
drwx------ 3 root root  4096 Jun  3  2008 ksocket-root
drwx------ 2 root root  4096 Apr 27  2008 orbit-root
- -rw------- 1 root root 23470 Nov 27 10:23 ppd_fVt5GO8
- -rw------- 1 root root 23486 Jan 22 11:37 ppd_fp6jW8k
sda64:~ # df -m
Filesystem           1M-blocks      Used Available Use% Mounted on
/dev/sda2                 2023       260      1661  14% /
udev                      1008         1      1008   1% /dev
/dev/sda1                   54        31        21  61% /boot
/dev/sda12               44790     28178     14337  67% /home
/dev/sda9                 6054      1505      4241  27% /opt
/dev/sda10                6054       169      5578   3% /tmp
/dev/sda5                 4038      1150      2684  30% /usr
/dev/sda6                 1512      1211       225  85% /usr/lib64
/dev/sda11                3027      2580       294  90% /usr/local
/dev/sda7                 3027      1978       896  69% /usr/share
/dev/sda8                 1512       556       879  39% /var
/dev/dm-0               234729     15558    207248   7%
/media/WDPassport250Enc
sda64:~ #  /usr/sbin/mysqld --skip-grant &
[1] 22514
sda64:~ # 090220 10:21:54 [ERROR] Fatal error: Please read "Security"
section of the manual to find out how to run mysqld as root!

090220 10:21:54 [ERROR] Aborting

090220 10:21:54 [Note] /usr/sbin/mysqld: Shutdown complete


[1]+  Exit 1                  /usr/sbin/mysqld --skip-grant
sda64:~ # /usr/bin/mysql -u root mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
sda64:~ #

I've already spent a day and a half trying to chase this down.  I don't
have any more time to mess around with this, and it would be helpful if
I could have this up and running today.  If you can assist, please reply
offlist, or give me a call at 214-724-7741.

Thanks,
Steve
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFJntkNSphIUSiVzgYRAhQcAJ9I/vqTDdKp+EqgMRQf6qYNr4pmygCdGpHh
2Ci+e1TxQeKKBwMYQ8OFhGQ=
=7+DG
-----END PGP SIGNATURE-----