alm数据库mysql_mysql

1. mysql启动

mysqld --console

2. mysql关闭

mysqladmin shutdown -uroot -proot

3. 免安装mysql配置：

启动mysql： mysqld --skip-grant-tables(跳过安全校验)， 修改mysql.user表里面的数据，最后flush privileges;

mysql  jdbc连接代码

1 Class.forName("com.mysql.jdbc.Driver");2

3 Connection connection = null;4 PreparedStatement preparedStatement = null;5 ResultSet resultSet = null;6

7 connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql", "root", "root");8 preparedStatement = connection.prepareStatement("select host, user, password from user");

4. tomcat jdbc数据源JNDI配置

1

2

3 driverClassName="com.mysql.jdbc.Driver"url="jdbc:mysql://localhost:3306/mysql"username="root"password="root"

4 maxActive="30"maxIdle="30"maxWait="10000" />

5

5. mysql导出:

mysqldump -uroot -proot --max_allowed_packet=1048576 --net_buffer_length=16384 --extended-insert=FALSE --default-character-set=utf8 --routines --events "g2mdb" >export2.sql

6. mysql权限赋予

>grant all privileges on *.* to 'root'@'%‘ identified by 'root';

>flush privileges;

6. update join多表更新

update nms_res_device A

inner join (select ifnull(max(severity), 0) maxLevel, deviceId from nms_alm_info where clearTime = '0000-00-00 00:00:00' and isClear != 2 group by deviceId) TEMP

on A.deviceId = TEMP.deviceId

set A.alarmLevel = TEMP.maxLevel;