查看配置文件位置
/usr/local/mysql/bin/mysql --verbose --help | grep -A 1 'Default options'
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf /usr/local/mysql/my.cnf ~/.my.cnf
配置 spark-sql 链接 hive
1、启动hive的元数据服务 hive可以通过服务的形式对外提供元数据读写操作，通过简单的配置即可 编辑 $HIVE_HOME/conf/hive-site.xml,增加如下内容:
启动 hive metastore hive –service metastore 1>/dev/null 2>&1
将 $HIVE_HOME/conf/hive-site.xml copy $SPARK_HOME/conf/
[hadoop@hdp-node-01 spark] bin/spark-shell –master spark://hdp-node-01:7077
apt-get install libaio1 libaio-dev
下载 mysql-8.0.11 二进制安装包
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz 解压文件 sudo tar zxvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz -C /usr/local/ sudo mv /usr/local/mysql-8.0.11-linux-glibc2.12-x86_64 /usr/local/mysql 初始化 groupadd mysql useradd -r -g mysql -s /bin/false mysql mkdir -p /usr/local/mysql/data chown -R mysql:mysql /usr/local/mysql
/usr/local/mysql/bin/mysqld –initialize –user=mysql –datadir=/home/data/mysql_data [Note] A temporary password is generated for root@localhost: Bs1i(,kXwg #最后面的字符串为root密码。 /usr/local/mysql/bin/mysql_ssl_rsa_setup –datadir=/home/data/mysql_data 拷贝配置文件和启动脚本 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld vi /etc/init.d/mysqld basedir=/usr/local/mysql datadir=/usr/local/mysql/data
vi /etc/profile export MYSQL_HOME=/usr/local/mysql export PATH=$PATH:$MYSQL_HOME/bin 启动服务 /etc/init.d/mysqld start
设置root密码 使用初始化密码 /usr/local/mysql/bin/mysql -uroot -p’Bs1i(,kXwg’ mysql>ALTER user ‘root’@’localhost’ IDENTIFIED BY ‘root’; mysql>ALTER user ‘root’@’%’ IDENTIFIED BY ‘root’;
忘记初始化密码 vi /etc/my.cnf 在[mysqld]下增加一行 skip-grant-tables
/etc/init.d/mysqld restart /usr/local/mysql/bin/mysql -uroot mysql> use mysql; mysql> update user set authentication_string = ‘’ where user = ‘root’; mysql> exit
vi /etc/my.cnf 在[mysqld]下删除一行 skip-grant-tables
/usr/local/mysql/bin/mysql -uroot mysql> ALTER user ‘root’@’localhost’ IDENTIFIED BY ‘root’; mysql> exit
/etc/init.d/mysqld restart 设置开机启动 ####### CentOS ######## chkconfig mysqld on chkconfig –list
####### Ubuntu ######## update-rc.d mysql defaults update-rc.d -f mysql remove 设置防火墙 vi /etc/sysconfig/iptables -A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT 添加到库 vi /etc/ld.so.conf /usr/local/mysql/lib
ldconfig
下载 MySQL 二进制安装包
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.25-linux-glibc2.17-x86_64-minimal.tar.xz
##