最郁闷的问题之mysql 高手快来 {~_~!~_~}

共有 4 条评论

1. shenhua_sjp 于 2007-08-28 15:39:03发表:

   就 四个rpm包
   兄弟详细看下
   [root@localhost mysql]# rpm -ivh --force MySQL-server-4.0.21-0.i386.rpm
   [root@localhost mysql]# rpm -ivh --force MySQL-client-4.0.21-0.i386.rpm
   [root@localhost mysql]# rpm -ivh --force MySQL-devel-4.0.21-0.i386.rpm
   [root@localhost mysql]# rpm -ivh --force MySQL-shared-4.0.21-0.i386.rpm
   [root@localhost mysql]#mysql
   mysql操作
   show databases； //显示数据库
   create database shenhua //创建数据库shenhua
   use shenhua //链接shenhua数据库
   show tables; //显示表
   select * from 表名
   Dorp shenhua //删除数据库
   \../ shenhua.sql //导入数据库

2. JustForLOVE 于 2007-08-27 21:35:24发表:

   :0(1 :0D1 :0)1

3. shenhua_sjp 于 2007-08-24 09:58:49发表:

   [root@localhost src]# rpm -ivh MySQL-server-4.0.21-0.i386.rpm
   warning: MySQL-server-4.0.21-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f
   5
   Preparing... ########################################### [100%]
   1:MySQL-server ########################################### [100%]
   Preparing db table
   Preparing host table
   Preparing user table
   Preparing func table
   Preparing tables_priv table
   Preparing columns_priv table
   Installing all prepared tables
   060424 9:56:58 Warning: Asked for 196608 thread stack, but got 126976
   060424 9:56:58 /usr/sbin/mysqld: Shutdown Complete
   
   
   PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
   To do so, start the server, then issue the following commands:
   /usr/bin/mysqladmin -u root password 'new-password'
   /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
   See the manual for more instructions.
   
   Please report any problems with the /usr/bin/mysqlbug script!
   
   The latest information about MySQL is available on the web at
   http://www.mysql.com
   Support MySQL by buying support/licenses at https://order.mysql.com
   
   [root@localhost src]# rpm -ivh MySQL-client-4.0.21-0.i386.rpm
   warning: MySQL-client-4.0.21-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f
   5
   Preparing... ########################################### [100%]
   1:MySQL-client ########################################### [100%]
   [root@localhost src]# rpm -ivh MySQL-devel-4.0.23-0.i386.rpm
   warning: MySQL-devel-4.0.23-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
   Preparing... ########################################### [100%]
   1:MySQL-devel ########################################### [100%]
   [root@localhost src]# rpm -ivh MySQL-shared-4.0.23-0.i386.rpm
   warning: MySQL-shared-4.0.23-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f
   5
   Preparing... ########################################### [100%]
   1:MySQL-shared ########################################### [100%]
   [root@localhost src]# mysql
   Welcome to the MySQL monitor. Commands end with ; or \g.
   Your MySQL connection id is 1 to server version: 4.0.21-standard
   
   Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
   
   mysql>
   
   对照看下 郁闷啊

4. shenhua_sjp 于 2007-08-24 09:00:46发表:

   启动方法都试了 不行 /etc/initd/mysql start service mysqld start
   在sbin里启动时 出现060424数字 在安装service 时也会出现。到底是什么？〉
   [root@localhost mysql]# /usr/sbin/mysqld start
   060424 8:43:22 Warning: Asked for 196608 thread stack, but got 126976
   Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
   060424 8:43:22 Aborting
   
   060424 8:43:22 /usr/sbin/mysqld: Shutdown Complete