我在solaris上安装了一个mysql，安装用户是root，使用的格式是pkg.gz

安装过程中没有报错信息，安装目录是在/opt/mysql下，我直接到bin目录下用root用户运行mysqld_safe --users=mysql &出现如下提示：
[root@Solaris bin]# ./mysqld_safe --users=mysql &
[1] 883
[root@Solaris bin]# Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/Solaris.pid
080508 15:48:25  mysqld ended


[1]+  Done                    ./mysqld_safe --users=mysql


直接运行mysql报错如下：
[root@Solaris bin]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

用mysqladm命令报错如下：
[root@Solaris bin]# mysqladmin status
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

请问是我哪里设置错误了？ 请高手指点一下，谢谢了！

我用tar格式的重新装了一下也不行  
/usr/local/mysql/bin>mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

郁闷！

QUOTE:

---

原帖由 risepp 于 2008-5-8 16:54 发表
我用tar格式的重新装了一下也不行  
/usr/local/mysql/bin>mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

郁闷！

---

你没 启动 mysqld当然会报错了，吧你的 *.err信息贴出来，估计是没权限的问题（一般情况下都 是这样），因为你没修改my.cnf

看一下 mysql.sock是指定到那的

在哪里可以查看日志信息啊？ mysql.sock是在my.cnf制定的么？ 我去看看，谢谢啊！

QUOTE:

---

原帖由 risepp 于 2008-5-8 21:39 发表
在哪里可以查看日志信息啊？ mysql.sock是在my.cnf制定的么？ 我去看看，谢谢啊！

---

若 没有 特别 制定log-error的 路径为 名称的话，就 是在 数据目录里 ，*.err 就 是

080508 13:51:56  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080508 13:51:56  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080508 13:51:57  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...
080508 13:51:57  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
080508 13:51:58  InnoDB: Started; log sequence number 0 0
080508 13:51:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
080508 13:51:58  mysqld ended

080508 13:52:25  mysqld started
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
080508 13:52:25  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
080508 13:52:25  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 3
9 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 8
3 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
080508 13:52:26  InnoDB: Started; log sequence number 0 43655
080508 13:52:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
080508 13:52:26  mysqld ended

080508 15:48:25  mysqld started
080508 15:48:25 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'users=mysql'

080508 15:48:25  mysqld ended

错误日志内容如下，我重新安装了一下mysql  还是不行。默认solaris mysql的参数文件是不是放在如下路径
❑ Global options: /etc/my.cnf
❑ Server-specific options: <data directory>/my.cnf
❑ User-specific options: ~/.my.cnf

我都没找到，是不是我安装有问题唷？

080508 13:52:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

这个表不存在还是权限不够啊？ 我安装的时候没有报错啊。我去查查看！