首页 Soft PlugIn RAN乱 Dev开发 Info资料 English WAP 留言 登陆 注册
-
Posted by Yippee | 评论(1) | 引用(0) | 阅读2067次
Linux 安装 MYSQL1

因为REDHAT小红帽自带的实在不好配置,所以干脆停止了自带的服务,准备自己另行安装

Linux downloads (platform notes)
Linux (x86, glibc-2.2, static (Standard only), gcc) Standard 4.1.14 29.5M Pick a mirror
MD5: 1b5be3d40d89da896f831f1d00dd705b &line; Signature
  Max 4.1.14 41.4M Pick a mirror
MD5: 8c981d54a9d03beda25093462a74a31d &line; Signature
  Debug 4.1.14 48.0M Pick a mirror

我下载的是Max
lynx http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-max-4.1.14-pc-linux-gnu-i686.tar.gz/from/http://download.softagency.net/MySQL/

tar zxvf mysql-max-4.1.14-pc-linux-gnu-i686.tar.gz

[root# www.shengfang.org tmp]# mv mysql-max-4.1.14-pc-linux-gnu-i686 /home/sf/www
[root# www.shengfang.org tmp]# ls
apache               mysql-max-4.1.14-pc-linux-gnu-i686.tar.gz  php-4.4.0.tar.gz         t1
httpd-2.0.54.tar.gz  php-4.4.0                                  phpMyAdmin-2.6.4.tar.gz
[root# www.shengfang.org tmp]# cd ..
[root# www.shengfang.org sf]# cd www
[root# www.shengfang.org www]# ls
mysql-max-4.1.14-pc-linux-gnu-i686
[root# www.shengfang.org www]# mv mysql-max-4.1.14-pc-linux-gnu-i686/ mysql41
[root# www.shengfang.org www]# ls
mysql41
[root# www.shengfang.org www]# cd mysql41/
[root# www.shengfang.org mysql41]# ls
bin        COPYING  docs               include         lib  mysql-test  scripts  sql-bench      tests
configure  data     EXCEPTIONS-CLIENT  INSTALL-BINARY  man  README      share    support-files
[root# www.shengfang.org mysql41]# mysql
ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO)
[root# www.shengfang.org mysql41]# mysql -u root -p
Enter password: www.shengfang.org
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.14-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from user
    -> ;
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
&line; Host      &line; User &line; Password         &line; Select_priv &line; Insert_priv &line; Update_priv &line; Delete_priv &line; Create_priv &line; Drop_priv &line; Reload_priv &line; Shutdown_priv &line; Process_priv &line; File_priv &line; Grant_priv &line; References_priv &line; Index_priv &line; Alter_priv &line;
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
&line; localhost &line; root &line; 565491d704013245 &line; Y           &line; Y           &line; Y           &line; Y           &line; Y           &line; Y         &line; Y           &line; Y             &line; Y            &line; Y         &line; Y          &line; Y               &line; Y          &line; Y          &line;
&line; mobile    &line; root &line;                  &line; Y           &line; Y           &line; Y           &line; Y           &line; Y           &line; Y         &line; Y           &line; Y             &line; Y            &line; Y         &line; Y          &line; Y               &line; Y          &line; Y          &line;
&line; localhost &line;      &line;                  &line; N           &line; N           &line; N           &line; N           &line; N           &line; N         &line; N           &line; N             &line; N            &line; N         &line; N          &line; N               &line; N          &line; N          &line;
&line; mobile    &line;      &line;                  &line; N           &line; N           &line; N           &line; N           &line; N           &line; N         &line; N           &line; N             &line; N            &line; N         &line; N          &line; N               &line; N          &line; N          &line;
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
4 rows in set (0.00 sec)

mysql>

默认密码 123456

网上很多资料说 ./CONFIG,结果~~
[root# www.shengfang.org mysql41]# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h mobile password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./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
Starting the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[root# www.shengfang.org mysql41]# Starting mysqld daemon with databases from /home/sf/www/mysql41/data
STOPPING server from pid file /home/sf/www/mysql41/data/mobile.pid
050915 14:24:24  mysqld ended


字体:

Permanant URI永久地址 http://www.shengfang.org/blog/p/linuxinstmysql1.php
Trackback URI引用地址 http://www.shengfang.org/blog/tb.php?tb_id=1126770683

2005年9月15日15:51星期四  [Dev开发] 追踪此文的RSS
Yippee在 2005年9月19日14:15星期一 评论:
linux 安装 MYSQL 2 (2005-9-19) http://www.shengfang.org/blog/p/LINUXINSTMYSQL2.php

称呼:    登陆   注册
   不注册,但记住我的信息
邮件:
(非必须)
评论: [UBB代码帮助]
粗体 斜体 下划线 链接 水平线 引用



验证码: 请输入你看见的数字
关闭UBB      提交时自动将内容复制到剪贴板

公告
Fire and Motion!

统计信息
[Yippee]||[统计]||日志:1790
在线: 11||用户: 2562 [列表]
今日:1892||到访:2671391
Rss:838362||评论:1584

最新日志

最新评论

友情链接

日历

最新引用

搜索

归档

杂项
Get RSS Feed (Version 2.0)
Get Atom Feed (Version 0.3)
编码:  UTF-8