2、选择安装类型,注意下图中选择“Custom”(自定义)选项,这样才能修改安装目录。
3、选择安装目录:程序默认安装到系统盘,在安装选项中选中“MySQL Server”,点击“Browse...”修改MySQL的安装目录。注意不要选择系统盘下的任何目录,以免相关数据库因为 *** 作系统的故障而产生灾难性后果(如数据文件丢失)
4、点击“浏览”修改MySQL安装目录为“d:\muse\install\mysql”
5、MySQL默认数据目录安装到系统盘,在安装选项中选中“Server data files”,点击“Browse…”修改MySQL的数据安装目录。注意不要选择系统盘下的任何目录,以免相关数据库因为 *** 作系统的故障而产生灾难性后果(如数据文件丢失)
6、修改MySQL的数据安装目录,数据安装目录与mysql同一级目录,文件夹名称mysqldata
7、点击“Next”
8、点击“Install”开始安装
9、下面两步没有特殊选项,直接点击“Next”继续安装
10、选择“Detailed Configuration”项,点击“Next”
注意,下面要选择“Server Machine”, 点击“Next”
11、选择“Multifunctional Database”,点击“Next”继续
12、InnoDB Tablespace Setting选择Installation Path,点击“Next”继续
13、设置同时连接到MySQL服务器的连接数,注意,下面要选择“Manual Setting”项,并选择“Concurrent connections”为“1000”, 点击“Next”
14、设置服务端口,默认为“3306”, 点击“Next”
15、选择默认字符集,下面选择“Manual Selected Default Character Set /Collation”项,并选择默认字符集为“utf8”, 点击“Next”
16、安装MySQL为Windows *** 作系统的服务,“Service Name”(服务名称)项选择“MySQL”,并勾选“Launch the MySQL Server automatically”( *** 作系统启动时自动启动MySQL服务),点击“Next”
17、设置MySQL管理员root的密码,下面设置为“12345678”为例,点击“Next”
18、点击“Execute”,开始执行配置
19、点击“Finish”完成配置
mysql-5.6.14-win32为免安装解压缩版,安装版(http://dev.mysql.com/downloads/installer/5.5.html#downloads)存在很多弊端。mysql 5.6.14 win7 32位免安装版配置
1.下载mysql 5.6.14;下载地址:http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.14-win32.zip
2.解压到自定义目录,我的是D:\ProgramFiles\mysql5614win32\bin
3.复制根目录下的my-default.ini,改名为my.ini,my.ini用下面内容替换
[client]
port=3306
default-character-set=utf8
#客户端字符类型,与服务端一致就行,建议utf8
[mysqld]
port=3306
character_set_server=utf8
#服务端字符类型,建议utf8
basedir=D:\ProgramFiles\mysql5614win32
#解压根目录
datadir=D:\ProgramFiles\mysql5614win32\data
#解压根目录\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\ProgramFiles\mysql5614win32\bin\mysqld.exe
#解压根目录\bin\mysqld.exe
4.环境变量配置
你的解压目录
MYSQL_HOME D:\ProgramFiles\mysql5614win32
path后面加上%MYSQL_HOME%\bin
5.找到C:\Windows\System32\cmd.exe,右键-以管理员身份运行(很重要,否则有权限问题,会报错:Install/Remove of the Service Denied!),进入mysql解压目录bin子目录下,输入mysqld install MySQL --defaults-file="你的解压根目录\my.ini",提示:
Service successfully installed.
6.启动、停止、移出MYSQL服务
启动MYSQL服务:net start mysql
停止MYSQL服务:net stop mysql
移出mysql服务:mysqld-nt --remove
7.修改root密码:
运行中输入cmd ,跳到安装目录/bin下,
D:\ProgramFiles\mysql5614win32\bin>mysql -uroot
D:\ProgramFiles\mysql5614win32\bin>show databases
D:\ProgramFiles\mysql5614win32\bin>use mysql
D:\ProgramFiles\mysql5614win32\bin>UPDATE user SET password=PASSWORD("root") WHERE user='root'
D:\ProgramFiles\mysql5614win32\bin>FLUSH PRIVILEGES
D:\ProgramFiles\mysql5614win32\bin>QUIT
FLUSH PRIVILEGES:强制让MySQL重新加载权限,即刻生效
MySql安装
yum -y install libaio
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
cd /usr/local/soft/mysql/src
mkdir ../5.7.24_3306 &&tar -xzvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz -C ../5.7.24_3306 --strip-components 1
mkdir -p /usr/local/soft/mysql/5.7.24_3306/{run,data,logs,bin_log,sock,cert}
groupadd mysql &&useradd -r -g mysql -s /bin/false mysql
cd /usr/local/soft/mysql/5.7.24_3306/bin &&./mysqld --initialize
--explicit_defaults_for_timestamp
--user=mysql
--basedir=/usr/local/soft/mysql/5.7.24_3306
--datadir=/usr/local/soft/mysql/5.7.24_3306/data
--lc_messages_dir=/usr/local/soft/mysql/5.7.24_3306/share
--lc_messages=en_US
2018-12-01T09:56:45.934627Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-12-01T09:56:46.056837Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-12-01T09:56:46.127141Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 69d028f9-f54f-11e8-9c4a-00163e08e793.
2018-12-01T09:56:46.130249Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-12-01T09:56:46.131377Z 1 [Note] A temporary password is generated for root@localhost: sDdPx3>.,oBi
cd /usr/local/soft/mysql/5.7.24_3306/bin &&./mysql_ssl_rsa_setup --datadir=/usr/local/soft/mysql/5.7.24_3306/cert
修改证书权限为644
cd /usr/local/soft/mysql/5.7.24_3306/bin &&./mysql -uroot -S /usr/local/soft/mysql/5.7.24_3306/sock/mysql.sock
use mysql
update user set host = '%', authentication_string = password('123456') where user = 'root'
select host,user,authentication_string from user
flush privileges
grant all privileges on . to 'root'@'%'
flush privileges
cat >/etc/systemd/system/3306.service <<EOF
[Unit]
Description=MySQL 3306
Documentation= http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target remote-fs.target nss-lookup.target
[Service]
Type=forking
PIDFile=/usr/local/soft/mysql/5.7.24_3306/run/mysql.pid
ExecStart=/usr/local/soft/mysql/5.7.24_3306/support-files/mysql.server start
ExecReload=/usr/local/soft/mysql/5.7.24_3306/support-files/mysql.server restart
ExecStop=/usr/local/soft/mysql/5.7.24_3306/support-files/mysql.server stop
PrivateTmp=true
[Install]
WantedBy=multi-user.target
EOF
systemctl enable 3306.service
1、
cd /usr/local/soft/mysql/5.7.24.3306/bin &&./mysqld_safe --skip-grant-tables &
cd /usr/local/soft/mysql/5.7.24.3306/bin &&./mysqld_safe --skip-grant-tables --skip-networking &
2、
./mysql -uroot -p -S /usr/local/soft/mysql/5.7.24.3306/sock/mysql.sock
3、
use mysql
update mysql.user set authentication_string=password('123456') where user='root'
flush privileges
mkdir -p /usr/local/soft/mysql/back/5.7.23_3306 &&cp -Rf /usr/local/soft/mysql/5.7.23_3306/* /usr/local/soft/mysql/back/5.7.23_3306
mkdir -p /usr/local/soft/mysql/back/5.7.24_3306 &&cp -Rf /usr/local/soft/mysql/5.7.24_3306/* /usr/local/soft/mysql/back/5.7.24_3306
CREATE USER 'sdyc'@'%' IDENTIFIED BY '123456'
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON sd_data.* TO 'sdyc'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON card_data.* TO 'sdyc'@'%'
SHOW GRANTS FOR sdyc
CREATE USER 'back'@'localhost' IDENTIFIED BY '123456'
GRANT SELECT, RELOAD, PROCESS, SHOW DATABASES, SUPER, LOCK TABLES, REPLICATION CLIENT ON . TO 'back'@'localhost'
SHOW GRANTS FOR back
REVOKE SELECT, INSERT, UPDATE, DELETE, EXECUTE ON sd_data.* FROM 'sdyc'@'%'
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)