redhat5.432位安装mysql5.6.17数据库及创建数据库实例、配置编码、卸载(五)

再接着重新打开个终端，登陆mysql，修改相应用户的密码：

root@localhost home]# mysql -uroot -p
mysql> use mysql;mysql> update user set password=PASSWORD('root') where User='root'; 
----修改用户访问权限： 
mysql> grant all privileges on *.* to 'root'@'192.168.1.%' identified by 'mysql' with grant option; 
mysql> flush privileges;
mysql> quit;

mysql -uroot -proot 登陆：

--这句话重新设置一次密码！
mysql> SELECT 1;ERROR 1820 (HY000): 
You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD('root'); 解决办法

安装并登录成功。

三、数据库及数据库实例相关配置：

mysql数据库安装完成后，需要创建数据库实例，需要设置实例的编码，否则使用hibernate写数据时，可能报如下错误：

Hibernate: 
    insert 
    into
        Operlog
        (operCon, operIp, operName, operRes, operSql, operTime, operator) 
    values
        (?, ?, ?, ?, ?, ?, ?)
- SQL Error: 1366, SQLState: HY000
- Incorrect string value: '\xE7\x94\xA8\xE6\x88\xB7...' for column 'operCon' at row 1
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.sunlight.apply.entities.Operlog]; uncategorized SQLException for SQL [insert into Operlog (operCon, operIp, operName, operRes, operSql, operTime, operator) values (?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE7\x94\xA8\xE6\x88\xB7...' for column 'operCon' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE7\x94\xA8\xE6\x88\xB7...' for column 'operCon' at row 1
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:694)
at com.sunlight.apply.daoImpl.UserLoginDaoImpl.getUser(UserLoginDaoImpl.java:296)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.ao