Page History

[ytl@net-desk1:/opt/mysql/current/bin]$ sudo -s
[root@net-desk1 bin]# cat /var/lib/mysql/
ibdata1                          ib_logfile1                      net-desk1.slac.stanford.edu.err  
ib_logfile0                      mysql.sock                       
[root@net-desk1 bin]# cat /var/lib/mysql/net-desk1.slac.stanford.edu.err 
060830 11:03:15  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060830 11:03:15  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060830 11:03:16  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...
060830 11:03:16  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
060830 11:03:17  InnoDB: Started; log sequence number 0 0
060830 11:03:17 [ERROR] /opt/mysql/current/bin/mysqld: \
  Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
060830 11:03:17 [ERROR] Can't start server: can't create PID file: No such file or directory
060830 11:03:17  mysqld ended

[ytl@net-desk1:/opt/mysql/current/bin]$ \
  ./mysqladmin --socket=/var/lib/mysql/mysql.sock -u root password '#######'
[ytl@net-desk1:/opt/mysql/current/bin]$ \
  ./mysqladmin --socket=/var/lib/mysql/mysql.sock -u root -h net-desk1.slac.stanford.edu password '########'