(一) 挂载目录,使windows与linux成功通信
1. 首先在windows上面建立一个共享目录@share_folder,并将所需的安装软件放置到该目录
2. 进入linux进行挂载
mount –t cifs –o username=”your_windows_username”,(请忽略回车)
password=”your_windows_password”(此处空格,请忽略回车)
//your_windows_ip_address/\@share_folder /linux挂载区
例子:mount –t cifs –o username=”mylovedog”,password=”123456” //192.168.1.10/\@share_folder /mnt
3. 进入linux终端,在/usr/local/下创建mytools目录,并将/mnt下的mysql安装文件拷贝到/usr/local/mytools目录下
cd /usr/local
mkdir mytools
cp /mnt/Mysql-* /usr/local/mytools
4. 本文使用的安装程序为:
[root@localhost mysql]# uname -ar
Linux localhost.localdomain 2.6.18-128.el5 #1 SMP Wed Jan 21 10:44:23 EST 2009 i686 i686 i386 GNU/Linux
[root@localhost mysql]# ls /usr/local/mytools/ (官网下载)
MySQL-client-5.5.8-1.linux2.6.i386.rpm MySQL-server-5.5.8-1.linux2.6.i386.rpm
(二) mysql的安装与配置
[root@localhost mytools]# rpm -ivh MySQL-server-5.5.8-1.linux2.6.i386.rpm
Preparing... ########################################### [100%]
1:MySQL-server ########################################### [100%]
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'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
See the manual for more instructions.
Please report any problems with the /usr/bin/mysqlbug script!
(说明:
1. 出现以上信息,表明已经安装成功,需要到/usr/bin下设置root账号
2. RPM(RedHat Package Manager)语法解析:
2.1RPM是以一种数据库记录的方式来将你所需要的套件安装到你的Linux主机的一套管理程序
2.2语法:rpm参数 待安装程序.rpm
2.3主要安装以rpm结尾的安装包,还有*.src.rpm结尾的,需要先SRPM(Source Code)编译成RPM,然后再安装
2.4RPM安装的程序都会被安装到预设目录中:
/etc | 一些设定文件放置的目录,例如/etc/crontab |
/usr/bin | 一些可执行档案 |
/usr/lib | 一些程序使用的动态函式库 |
/usr/share/doc | 一些基本的软件使用手册与说明文件 |
/usr/share/man | 一些man page档案 |
)
2.进入/usr/bin目录设定mysql的root账户密码
[root@localhost mytools]# /usr/bin/mysqladmin -u root password “manager”
bash: /usr/bin/mysqladmin: No such file or directory
(说明:系统提示找不到mysqladmin这个文件或目录,怎么办呢?开始排错吧:
1. 首先就是到/usr/bin目录下面查看所有以mysql开头的内容(ll mysql*),共发现14个文件或目录(mysqlbug、mysql_convert_table_format、mysqld_multi、mysqld_safe、mysqldumpslow、mysql_fix_extensions、mysqlhotcopy、mysql_install_db、mysql_secure_installation、mysql_setpermission、mysqltest、mysql_tzinfo_to_sql、mysql_upgrade、mysql_zap)确实没有mysqladmin,那又是什么原因呢?
2. 再去查看一下mysql server安装完成后各目录中的文件变化吧
2.1数据库目录/var/lib/mysql/
2.2配置文件目录/usr/share/mysql(mysql.server命令及配置文件)
2.3相关命令所在目录/usr/bin
2.4 启动脚本/etc/init.d(启动脚本文件mysql的目录)
3. 网上资料说只有安装了mysql-client端才会出现mysqladmin
mysqladmin is part of the mysql-client package, so you have to install that package in order to use mysqladmin, mysql etc
)
3.安装mysql client
[root@localhost mytools]# rpm -ivh MySQL-client-5.5.8-1.linux2.6.i386.rpm
Preparing... ########################################### [100%]
1:MySQL-client ########################################### [100%]
(说明:安装完成后查看(ll /usr/bin/mysql*),/usr/bin/目录下多了很多文件,由安装完server后的14个,变成了26个,并且有了mysqladmin文件
mysql
mysqlaccess
mysqlaccess.conf
mysqladmin
mysqlbinlog
mysqlbug
mysqlcheck
mysql_convert_table_format
mysqld_multi
mysqld_safe
mysqldump
mysqldumpslow
mysql_find_rows
mysql_fix_extensions
mysqlhotcopy
mysqlimport
mysql_install_db
mysql_secure_installation
mysql_setpermission
mysqlshow
mysqlslap
mysqltest
mysql_tzinfo_to_sql
mysql_upgrade
mysql_waitpid
mysql_zap
)
4.设置mysql的root管理员账号密码
[root@localhost bin]# mysqladmin -u root password manager
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
(说明:安装完client后直接执行不行,告诉我们不能连接到MySQL server,要求检查mysqld是否在运行并且socket文件'/var/lib/mysql/mysql.sock'是否存在
1. 查看mysql默认端口号3306是否被占用
1.1 netstat –an命令查看mysql默认端口3306的情况,没有查找到
[root@localhost bin]# netstat -an
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:878 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN