mysql super privilege

Original address: http://blog.sina.com.cn/s/blog_6fd605b50100q5es.html with mysqladmin change password hintMysqladmin:can ' t turn off logging; Error: ' Access denied; you need the SUPER privilege for this operation 'Workaround:Modify MySQL Login

Today, my colleague told me that the view he had built on MySQL was not able to be changed, and the following error was reported:SQL Error 1227:access denied; You need the SUPER privilege for this operationAt first, I thought it was the authority of

Because in the test MySQL master and slave read and write separation, with the root user set from the library to read-only, but the restart is effective after the discovery, the root user can still do update insert, when root with all privilege

MySQL permission bitsCN.com I. permission table Three permission tables in the mysql database: user, db, host The access process of the permission table is: 1) Check whether the connected IP address, user name, and password exist in the table from

User Rights Management mainly has the following functions:1. You can restrict which libraries a user accesses, which tables2. You can restrict which tables the user performs for select, CREATE, delete, delete, alter, etc.3. The IP or domain name

[Arrangement] MySQL autocommit bitsCN.com [Arrangement] MySQL autocommit By default, mysql enables auto commit. You can run the following command to view the settings at the session level and global level: 01mysql> select @@session.autocommit;02+-

I. Permission tableThree permission tables in the MySQL database: User, DB, hostThe access process of the permission table is:1) check whether the connected IP address, user name, and password exist in the table from the host, user, and password

--mysql Permission Description----------------------2014/06/09A Permission table3 permissions tables in MySQL database: User, DB, hostThe access process for the permission table is:1) First from the user table in the host, user, password 3 fields to

1. Modify the root user password to remove the empty passwordThe default installed MySQL root user is a blank password, for security purposes, must be modified as a strong password, so-called strong password, at least 8 bits, composed of letters,

As the platform of data management, the security of the database is determined by the internal security and network security of the system first. For system administrators, the first thing to ensure the security of the system itself, when installing