Before You StartSteps for a Fresh Installation of MySQLAdding the MySQL Yum RepositoryFirst, add the MySQL Yum repository to your system's repository list. This is a one-time operation, which can be performed by installing an RPM provided by MySQL. Follow these ste...【阅读全文】
2. Then we added skip-grant-tables under [mysqld] section.By skipping the grant table option it allows anyone to log in from anywhere and can do anything on the database.3 Then, we restarted the MySQL service using the command below:Now MySQL is configured to skip t...【阅读全文】
查看mysql版本:[root@localhost logs]# mysql -Vmysql Ver 14.14 Distrib 5.6.37, for linux-glibc2.12 (x86_64) using EditLine wrapperlower_case_table_names参数详解:lower_case_table_names=1其中0:区分大小写,1:不区分大小写查询当前设置:mysql> show variables like '%lower%';----...【阅读全文】
方法一curl -s https://packagecloud.io/install/repositories/Altinity/clickhouse/script.rpm.sh | bashyum install clicktail方法二go get github.com/Altinity/clicktailGOPATH=/usr/local go get github.com/Altinity/clicktailGOPATH=/usr/local go buildGOPATH=/usr/local go install在clickhouse创建新库...【阅读全文】