MYSQL5.5 _ X64 installation 1) download the Linux platform of Mysql two installation files, respectively, MySQL-server-5.5.15-1.rhel5.x86_64.rpm and MySQL-client-5.5.15-1.rhel5.x86_64.rpm 2) in the installation file path to install the server side, the command is as follows:
# rpm –ivh MySQL-service-5.5.15-1.rhel5.x86_64.rpm
3) install the client in the path of the installation file. The command is as follows:
# rpm –ivh MySQL-client-5.5.15-1.rhel5.x86_64.rpm
4) log on to Mysql. The command syntax is as follows:
mysql [-u username] [-h host] [-p[password]] [dbname]
Username and password are the username and password of MySQL respectively. The initial management account of mysql is root, and there is no password. Note: This root user is not a Linux system user. The default MySQL user is root. Because there is no password at first, you only need to type mysql for the first time.
[root@test1 local]# mysql
A. Import project 1) After logging in to Mysql, import the database file to Mysql and execute the following command:
# source cms.sql
2) Place the project file in tomcat/webapps/, access the corresponding host ip address through a browser, add the startup port number (tomcat port number), and check whether the tomcat Management page appears. If yes, the project is started successfully, otherwise, startup fails. Database Address Configuration: modify the configuration information of the jdbc. properties file in the war package: jdbc. url address, as shown below:
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;