他的最新文章
他的热门文章
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)MySQL 是最流行的关系型数据库管理系统，由瑞典MySQL AB公司开发，目前属于Oracle公司。MySQL所使用的SQL语言是用于访问数据库的最常用标准化语言。MySQL由于其体积小、速度快、总体拥有成本低，尤其是开放源码这一特点，一般中小型网站的开发都选择MySQL作为网站数据库。
1、所需软件
mysql-5.6.34.tar.gz
下载地址：
2、所需环境
1）卸载自带 mysql
# yum -y remove mysql*
2）将原配置文件删除或改名
# mv&/etc/my.cnf&/etc/my.cnf.old
1、配置yum源
1）将系统 rhel-server-7.3-x86_64-dvd.iso 文件拷贝到 /soft 目录下
# cp&rhel-server-7.3-x86_64-dvd.iso /soft/
2）建立挂载所需的目录
# mkdir -p /media/cdrom
3）挂载# mount -o loop /soft/rhel-server-7.3-x86_64-dvd.iso /media/cdrom
4）进入 /etc/yum.repo.d 目录，对yum 源进行设置# cd&/etc/yum.repo.d# vi server.repo
5）查看是否安装成功，显示有4751 个软件包，源配置成功# yum repolist
2、安装依赖
# yum -y install ncurses ncurses-devel openssl-devel bison gcc gcc-c++ make cmake
3、创建用户和组
# groupadd -r mysql
# useradd -g mysql -r -d /mydata/data mysql
4、解压安装包
# tar zxvf mysql-5.6.34.tar.gz
# cd mysql-5.6.34
#&cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/mydata/data -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/webserver/mysql/ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_INNODB_MEMCACHED=1 -DWITH_DEBUG=OFF -DWITH_ZLIB=bundled -DENABLED_LOCAL_INFILE=1 -DENABLED_PROFILING=ON -DMYSQL_MAINTAINER_MODE=OFF -DMYSQL_DATADIR=/usr/local/webserver/mysql/data -DMYSQL_TCP_PORT=3306
# make install
7、查看是否安装成功
查看mysql版本
# /usr/local/mysql/bin/mysql --version
1、更改&/usr/local/mysql 目录所属
# cd /usr/local
# chown -R mysql:mysql mysql
2、安装perl
# yum -y install perl*
3、初始化数据库
# mkdir -p /mydata/data
# cd&/usr/local/mysql
# ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mydata/data
Installing MySQL system tables... 13:24:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 13:24:13 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 13:24:13 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.34) starting as process 4076 ... 13:24:13 4076 [Note] InnoDB: Using atomics to ref count buffer pool pages 13:24:13 4076 [Note] InnoDB: The InnoDB memory heap is disabled 13:24:13 4076 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 13:24:13 4076 [Note] InnoDB: Memory barrier is not used 13:24:13 4076 [Note] InnoDB: Compressed tables use zlib 1.2.7 13:24:13 4076 [Note] InnoDB: Using CPU crc32 instructions 13:24:13 4076 [Note] InnoDB: Initializing buffer pool, size = 128.0M 13:24:13 4076 [Note] InnoDB: Completed initialization of buffer pool 13:24:13 4076 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 13:24:13 4076 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 13:24:13 4076 [Note] InnoDB: Database physically writes the file full: wait... 13:24:13 4076 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 13:24:14 4076 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 13:24:16 4076 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 13:24:16 4076 [Warning] InnoDB: New log files created, LSN=45781 13:24:16 4076 [Note] InnoDB: Doublewrite buffer not found: creating new 13:24:16 4076 [Note] InnoDB: Doublewrite buffer created 13:24:16 4076 [Note] InnoDB: 128 rollback segment(s) are active. 13:24:16 4076 [Warning] InnoDB: Creating foreign key constraint system tables. 13:24:16 4076 [Note] InnoDB: Foreign key constraint system tables created 13:24:16 4076 [Note] InnoDB: Creating tablespace and datafile system tables. 13:24:16 4076 [Note] InnoDB: Tablespace and datafile system tables created. 13:24:16 4076 [Note] InnoDB: Waiting for purge to start 13:24:16 4076 [Note] InnoDB: 5.6.34 log sequence number 0 13:24:16 4076 [Note] RSA private key file not found: /mydata/data//private_key.pem. Some authentication plugins will not work. 13:24:16 4076 [Note] RSA public key file not found: /mydata/data//public_key.pem. Some authentication plugins will not work. 13:24:19 4076 [Note] Binlog end 13:24:19 4076 [Note] InnoDB: FTS optimize thread exiting. 13:24:19 4076 [Note] InnoDB: Starting shutdown... 13:24:19 4076 [Note] InnoDB: S log sequence number 1625977OK
Filling help tables... 13:24:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 13:24:20 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap. 13:24:20 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.34) starting as process 4098 ... 13:24:20 4098 [Note] InnoDB: Using atomics to ref count buffer pool pages 13:24:20 4098 [Note] InnoDB: The InnoDB memory heap is disabled 13:24:20 4098 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 13:24:20 4098 [Note] InnoDB: Memory barrier is not used 13:24:20 4098 [Note] InnoDB: Compressed tables use zlib 1.2.7 13:24:20 4098 [Note] InnoDB: Using CPU crc32 instructions 13:24:20 4098 [Note] InnoDB: Initializing buffer pool, size = 128.0M 13:24:20 4098 [Note] InnoDB: Completed initialization of buffer pool 13:24:20 4098 [Note] InnoDB: Highest supported file format is Barracuda. 13:24:20 4098 [Note] InnoDB: 128 rollback segment(s) are active. 13:24:20 4098 [Note] InnoDB: Waiting for purge to start 13:24:20 4098 [Note] InnoDB: 5.6.34 log sequence number 1625977 13:24:20 4098 [Note] RSA private key file not found: /mydata/data//private_key.pem. Some authentication plugins will not work. 13:24:20 4098 [Note] RSA public key file not found: /mydata/data//public_key.pem. Some authentication plugins will not work. 13:24:20 4098 [Note] Binlog end 13:24:20 4098 [Note] InnoDB: FTS optimize thread exiting. 13:24:20 4098 [Note] InnoDB: Starting shutdown... 13:24:21 4098 [Note] InnoDB: S log sequence number 1625987OK
To start mysqld at boot time you have to copysupport-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:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h test password 'new-password'
Alternatively you can run:
/usr/local/mysql/bin/mysql_secure_installation
which will also give you the option of removing the testdatabases and anonymous user created by default.
This isstrongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; /usr/local/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql- perl mysql-test-run.pl
Please report any problems at http://bugs.mysql.com/
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
New default config file was created as /usr/local/mysql/my.cnf andwill be used by default by the server when you start it.You may edit this file to change server settings
WARNING: Default config file /etc/my.cnf exists on the systemThis file will be read by default by the MySQL serverIf you do not want to use this, either remove it, or use the--defaults-file argument to mysqld_safe when starting the server
-------------------------------------------------------------------------------------------------------------------------
可能出现的错误：
bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory
安装 perl 后问题解决
-------------------------------------------------------------------------------------------------------------------------
&4、配置文件
# cp support-files/my-default.cnf /etc/my.cnf
5、添加到服务
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chkconfig --add mysqld
# chkconfig mysqld on
6、添加到环境变量
# echo "export PATH=$PATH:/usr/local/mysql/bin" && /etc/profile
添加到&/etc/profile 后，为什么没有生效呢？
别忘了执行下一步：
# source /etc/profile
# service mysqld start
# mysql -uroot -p
初始没有密码，直接回车
9、设置密码
# mysqladmin -uroot password 要设置的密码（加不加引号都可以）
或者# mysqladmin -u用户名 -p旧密码 password 新密码（加不加引号都可以）
mysql&&SET PASSWORD FOR '用户名'@'主机' = PASSWORD('密码');
mysql& update mysql.user set authentication_string=PASSWORD('要设置的密码') where user='root';
mysql& # 刷新数据库权限
10、创建用户
1）创建用户
mysql&&create user '用户名'@'%' identified by '密码';
2）创建用户并授权
mysql&&grant all privileges on *.* to 用户名@'%' identified by '密码'
mysql&# 刷新数据库权限
五、常用命令
启动：service mysqld start
停止：service mysqld stop
重启：service mysqld restart
重载配置：service mysqld reload
阅读(...) 评论()苹果/安卓/wp
积分 614, 距离下一级还需 186 积分
权限: 自定义头衔, 签名中使用图片
道具: 彩虹炫, 涂鸦板, 雷达卡, 热点灯, 金钱卡, 显身卡, 匿名卡, 抢沙发下一级可获得
权限: 隐身
购买后可立即获得
权限: 隐身
道具: 金钱卡, 彩虹炫, 雷达卡, 热点灯, 涂鸦板
开心签到天数: 18 天连续签到: 1 天[LV.4]偶尔看看III
各位，我想做一个ADF检验，但是下载uroot包时发现library中根本没有这个包，还请知道的朋友给我个指导。
在此谢过了～
一份耕耘，一份收获。
ywh 发表于
http://help.rmetrics.org/fUnitRoots/html/UnitrootUrcaInterface.html谢谢，我在tseries包里找到了adf.test(),这个函数。
你提供的有点复杂，包里的不懂什么意思。
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
&nbsp&nbsp|
如有投资本站或合作意向，请联系（010-）；
邮箱：service@pinggu.org
投诉或不良信息处理：（010-）
论坛法律顾问：王进律师安装 3DR UBlox GPS + Compass 模块
Installing the 3DR UBlox GPS + Compass Module
Note! If you are only installing the stand alone external Magnetometer without the GPS go (Here!)
Connecting the GPS / Magnetometer Module
A GPS module provides enhanced positioning for autonomous flight. Connect your GPS to your autopilot by following these steps.
Note: The 3DR UBLOX GPS / Magnetometer module currently works with APM:Plane, APM:Rover and the APM:Copter version 3.0 Beta firmware. The module will be fully supported in APM:Copter with version 3.0 “Release” code and it does not work with the current APM:Copter 2.9.x release firmware.
3DR GPS uBlox with Onboard Compass
The 3DR GPS uBlox with Onboard Compass is intended for use with APM 2.6 (for external compass).
This module permits the GPS to be mounted separately from the flight control module so that it can have the best clear (view) of the sky.
It also permits the the compass to be distanced from interfering magnetic fields.
The magnetometer is strongly affected by nearby DC power wiring and the batteries and the module should be distanced from them by at least several inches and power and ground wires should be twisted together where possible.
The Module should also be clear of nearby iron containing metallic objects, (use nylon or non magnetic stainless steel hardware and nylon or aluminum standoffs to mount the module).
Place your GPS / Compass module on the outside of your vehicle (in an elevated position if appropriate) with a clear view of the sky, as far as possible from the motors and ESCs, with the arrow facing forward.
Connect the GPS module to the APM 2.6 using the two cables included with the GPS as shown below.
3DR GPS uBlox with Onboard Compass includes two connector cables: one 4-position cable and one 5-position-to-6-position cable. To connect the GPS module to APM 2.6, connect the GPS to the APM GPS port using the 5-position-to-6- connect the GPS to the APM I2C port using the 4-position cable.
Note: If the GPS / Magnetometer board is mounted in its correct direction (arrow pointing forward) and the Flight controller board is also mounted right side up with its arrow pointing forward, the (COMPASS_ORIENT) parameter will need to be set to (Roll 180) or “8″ because the compass is upside down under the GPS modules antenna.
Start Mission Planner and connect your flight control board: APM or PX4 and select the “Connect” tab.
Select the “Hardware” tab, then select the left menu “Mandatory Hardware” tab and then select the “Compass” tab.
Select the down arrow in the compass orientation pull down item and select “ROTATION_ROLL_180″.
Note: You will need to set the Magnetometer Orientation Parameter (COMPASS_ORIENT) in the Mission Planner Advanced Parameter List correctly to accommodate the Magnetometer’s orientation.
Note: If the Flight controller board is used in an alternate orientation (or upside down), the (COMPASS_ORIENT) parameter will need to also be adjusted to accommodate the Flight controller boards orientation as well as it’s own. (They are additive).
In order to properly setup the Magnetometer you should follow one of the Configuration procedures (Here!)
INSTRUCTIONS FOR THE PX4
The PX4 does not require any modifications to the PX4 boards at all.
The GPS connector plugs into the PX4FMU’s GPS connector.
When the external Magnetometer is plugged into the PX4IO boards I2C port it is automatically detected and used and the internal one is disabled.
The PX4IO boards I2C port is the 4 pin connector located on the board side opposite the Servo Out connectors in the second row of connectors in and next to the board mounting hole.
The “COMPASS_ORIENT” Parameter will need to be set as described previously to include a “Roll 180″.
3DR GPS uBlox without Onboard Compass and APM 2.5
The 3DR GPS uBlox without on board Compass is intended for use with APM 2.5.
To install your GPS module without compass, mount to the outside of your vehicle with a clear view of the sky and connect to the APM 2.5 GPS port using the 5-position-to-6-position connector cable.
The APM 2.5 can also be used with the combination GPS / compass module by wiring the magnetometer and cutting the solder bridge as shown (Here!) and then following the instructions above for the APM 2.6.
纠错,疑问,交流:
获取最新文章:
扫一扫右上角的二维码加入“创客智造”公众号华硕r414uv7200笔记本安装win7系统操作教程_u深度
　　华硕r414uv7200是一款14英寸校园学生本，仅为27.6mm的厚度和1.7kg的重量便携性非常出色，配合led背光屏适合外出携带办公使用。那么这款笔记本如何安装win7操作系统呢?下面小编就为大家介绍华硕r414uv7200笔记本安装win7系统操作教程。
　　安装步骤：
　　1、首先将u盘制作成u深度u盘启动盘，接着前往相关网站下载win7系统存到u盘启动盘，重启电脑等待出现开机画面按下启动快捷键，选择u盘启动进入到u深度主菜单，选取&【02】u深度win8 pe标准版(新机器)&选项，按下回车键确认，如下图所示：
　　2、在pe装机工具中选择win7镜像放在c盘中，点击确定，如下图所示：
　　3、此时在弹出的提示窗口直接点击&确定&按钮，如下图所示：
　　4、随后安装工具开始工作，我们需要耐心等待几分钟， 如下图所示：
　　5、完成后，弹跳出的提示框会提示是否立即重启，这个时候我们直接点击立即重启就即可。
　　6、此时就可以拔除u盘了，重启系统开始进行安装，我们无需进行操作，等待安装完成即可。
　　通过小编介绍的方法操作，用户们就可以简单的让华硕r414uv7200笔记本安装win7系统了，想要了解更多更全面的相关内容，请关注!
使用教程 BIOS设置 常见问题
神舟战神k680d-g4d1是一款15.6英寸笔记本产品，机身...
热门u深度使用教程
u深度视频教程推荐
热门BIOS设置教程
热门常见问题
当前位置： >
华硕r414uv7200笔记本安装win7系统操作教程}