Shulou(Shulou.com)06/01 Report--

1. Copy the database file:

Scp glloans_haierdb_20170726.sql.gz root@10.164.197.245:/root

2. Decompress the database

Gunzip glloans_haierdb_20170726.sql.gz

3. Log in to the data mysql database. This does not have a password, so you must log in as follows:

Mysql-ucmis_haier

4. See what databases are available:

Show databases

5. Find that there is no database to create, create the database

Create database cmis_haierdb

Find an error report

Solution:

6. Modify the my.cnf file under etc and add:

Skip-grant-tables, release permissions, restart mysql

7. Log in to mysql again:

Mysql-ucmis_haier

8. Execute:

Use mysql

Update user set password=password ('new password') WHERE User='cmis_haier'

Flush privileges

Restart mysql: service mysqld restart

The rest can see what databases exist under this user:

Shows databases

Create the database:

Create databases cmis_haierdb

That's it, then: use cmis_haierdb

Then: source/ xd_t_datasource/***.sql

So far, the database has been deployed.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.