Tag:Install MySQL

  • Novice how to install MySQL (pro test is effective)


    1、 Software download MySQL download and installation:Download address of official website: https://www.mysql.com/ Or download locally 2、 Installation instructions If you are uninstalling and reinstalling the software, please see this tutorial to ensure that it is uninstalled cleanly.How to uninstall MySQL? (valid for personal test) Confirm whether your computer name is Chinese. If so, you’d better […]

  • The method of installing MySQL database in CentOS


    1. First of all, download the installation file of MySQL. I’m installing version 5.1.7 of MySQL, 2. Install MySQL database server Enter the folder where the installation package is located, execute the command RPM – IVH MySQL server-5.1.7-0.i386.rpm to install MySQL server. If there is a conflict with the original version, execute the RPM – […]

  • The problem and solution of no prompt for password when installing MySQL in Ubuntu 18.04


    The installation of MySQL 5.7 in Ubuntu 1804 is very detailed. Execute command to install MySQL sudo apt install mysql-server sudo apt install mysql-client After installation, check whether it starts sudo ps aux | grep mysql If it has been started, you can see the corresponding information after executing the above command. If it has […]

  • Install MySQL in Ubuntu to change the default password


    Step 1: enter the directory: CD / etc / MySQL, and view the debian.cnf file Step 2: log in to MySQL using the account and password in the figure above. Step 3: view the library in the database. Step 4: use MySQL library. Step 5: use the following statement to set the account password:update user […]

  • CentOS installation of mysql8. X tutorial


    MySQL installation (4,5,6 can be omitted) Statement: CentOS version is 7.6 and MySQL version is 8.0.17 1. First of all, you need to uninstall the MySQL related files, including MariaDB. RPM – PA | grep MySQL # will delete the search result with ‘RM – RF file name’, if not, skip it RPM – PA […]

  • Command details of installing mysql5.7 database under CentOS 7.2


    MySQL server installed a version 8.0.12, the local version is a version 5.7, today removed the re installed version 5.7, the following is all the name of the command, follow will be installed. Configuration source wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm yum localinstall mysql57-community-release-el7-8.noarch.rpm # yum repolist enabled | grep “mysql.*-community.*” Installation: yum install mysql-community-server mysql start systemctl start […]

  • Installation of decompression version of MySQL under Windows 10


    MySQL installation is divided into installation version and decompression version. The installation version is mainly installed by an EXE program with an interface and mouse click. Xiaobai recommends using the installation version to install mysql. Compared with the installation version, the decompression version is more “pure” and has no superfluous things, but it is more […]

  • How to install MySQL under Windows


    1. Download installation package -Select the appropriate version according to your computer system: https://dev.mysql.com/downloads/mysql/ 2. Configure environment variables 2.1 decompress the downloaded package 2.2 environmental variables The win 10 computer goes in like this 3. Generate data file In the directory where you unzip it, eg: F: program files / mysql-8.0.17-winx64 / bin, and run […]

  • Linux CentOS 6.5 uninstall, tar install MySQL tutorial


    Uninstall MySQL from the system 1. Check whether MySQL is currently installed in the system rpm -qa|grep -i mysql 2. Uninstall the current version of MySQL yum remove mysql mysql-server mysql-libs mysql-server Choose “Y” in the process of unloading Check again and no information indicates that it has been unloaded 3. Find the residual files […]

  • Install MySQL 8.0.17 and configure the method of remote access


    1、 Preparation before installation View database version command:mysql –version mysql-community-common-8.0.17-1.el7.x86_64.rpm mysql-community-libs-8.0.17-1.el7.x86_64.rpm mysql-community-client-8.0.17-1.el7.x86_64.rpm mysql-community-server-8.0.17-1.el7.x86_64.rpm 2、 Install RPM package Install the above RPM packages in turn, and the former and the latter are dependent. # rpm -ivh mysql-community-common-8.0.17-1.el7.x86_64.rpm # rpm -ivh mysql-community-libs-8.0.17-1.el7.x86_64.rpm # rpm -ivh mysql-community-client-8.0.17-1.el7.x86_64.rpm # rpm -ivh mysql-community-server-8.0.17-1.el7.x86_64.rpm 3、 Query the initial password of root […]

  • Complete tutorial for installing Apache, mysql, PHP, lamp on Ubuntu 18.04


    1. Install Apache $ sudo apt update && sudo apt install apache2 There will be a pause in the middle, asking whether to continue, inputythenenter. 2. Test Apache Check that Apache is installed correctly by checking the status of the Apache service $ sudo service apache2 status After viewing the status, you need to press […]

  • MySQL installation notes for MySQL


    1. Environmental preparation 1. MySQL installation path:/usr/local 2. CentOS 6.2 server (64 bit) 3. MySQL 5.7.28 download (64bit) wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz 2. MySQL installation 2.1 unzip and rename to MySQL 2.2 create the data directory under the MySQL directory 2.3 create MySQL user groups and users, and set user groups and users on MySQL directory 2.4 […]