本站网址： YippeeSoft开心软件

本文链接: 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.yippeesoft.com tmp]# mv mysql-max-4.1.14-pc-linux-gnu-i686 /home/sf/www
[root# www.yippeesoft.com 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.yippeesoft.com tmp]# cd ..
[root# www.yippeesoft.com sf]# cd www
[root# www.yippeesoft.com www]# ls
mysql-max-4.1.14-pc-linux-gnu-i686
[root# www.yippeesoft.com www]# mv mysql-max-4.1.14-pc-linux-gnu-i686/ mysql41
[root# www.yippeesoft.com www]# ls
mysql41
[root# www.yippeesoft.com www]# cd mysql41/
[root# www.yippeesoft.com 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.yippeesoft.com mysql41]# mysql
ERROR 1045: Access denied for user \’root\’@\’localhost\’ (using password: NO)
[root# www.yippeesoft.com mysql41]# mysql -u root -p
Enter password: www.yippeesoft.com
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.yippeesoft.com 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.yippeesoft.com 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

原创文章，转载请注明： 转载自YippeeSoft开心软件

本文链接地址: Linux 安装 MYSQL1

历史博文

标签：, , ,