mysqladmin

() function to encrypt the PASSWORD in INSERT. If you specify database-level permissions, the User name and Host name are recorded in the User and Host columns of the db table. The database you authorize is recorded in the Db column, and the permissions you grant are recorded in the permission column. For Table-level and column-level permissions, the effect is similar. Create records in the tables_priv and columns_priv tables to record user names, host names, and databases, as well as related

MySQL review notes II bitsCN.com MySQL review notes II 1. set a password for the root administrator account Generally, the default MySQL root password is blank. if you have not set the root password before, use the mysqladmin command, You can use the following mysqladmin command to modify the root password: $ Mysqladmin-uroot-p password 123456 (Equivalent to

MySQL-Win32 compared with MySQL of Win32 and Unix has proved its stability. This version of MySQL has the same features as the corresponding Unix version, except the following: Win95 and thread Win95 loses about 200 bytes of memory for each thread creation. Therefore, if you have many connections, you should not run mysqld in Win95 for a long time, because every connection of MySQL creates a new thread! WinNT and Win98 cannot tolerate this bug. Blocking read MySQL uses one blocking read for eac

Use the update log file bitsCN.com in MySQL You cannot back up data at any time, but when your data is lost or the files in the database directory are damaged, you can only restore the files that have been backed up, and insert or update the data after this, you can't do anything about it. To solve this problem, you must use the update log. The update log records the SQL statements for updating, inserting, and deleting records in real time. Enable log When the -- log-update = file_name option is

described later. 　　4. several important MySQL directories After MySQL is installed, its database files, configuration files, and command files are not installed in the default directory of SQLServer. it is very important to understand these directories, especially for Linux beginners, because the directory structure of Linux itself is complicated, if you do not know the installation directory of MySQL, you will not be able to learn it in depth. The following describes these directories. 1. Data

is followed by the user name.-p requires the password. press enter and enter the password at the enter password. Note: This mysql file is located in the/usr/bin directory. it is not a file with the startup file/etc/init. d/mysql described later. VII. several important MySQL directories After MySQL is installed, its database files, configuration files, and command files are not installed in the same directory as SQL Server by default. it is very important to understand these directories, especia

searches for [mysqld #] segments in my. cnf (or in the custom configuration file -- config-file). "#" can be any positive integer. This positive integer is the segment sequence mentioned below, I .e., GNR. The serial number of a segment is used as the parameter of mysqld_multi to distinguish different segments, so that you can control the startup, stop, or obtain report information of a specific mysqld process. The parameters in these groups are the same as those in the group required to start

directly modify the authorization table, you will notify the server to reload the authorization table, otherwise he will not know your change. You can execute a mysqladmin flush-privileges or mysqladmin reload command to force an overload. If you forget to do this, you will wonder why the server does not do what you want. The following GRANT statement creates a super user with ownership. Includes the abil

) installation # Make install 5. initialize the database # Mkdir-p/data0/dbdata/mysql/3306. # Mkdir-p/data0/dbdata/mysql/3307. # Mkdir-p/data0/dbdata/mysql/3308. # Chown-R mysql: mysql/data0/dbdata/mysql/3306 # Chown-R mysql: mysql/data0/dbdata/mysql/3307 # Chown-R mysql: mysql/data0/dbdata/mysql/3308 #/Usr/local/mysql/scripts/mysql_install_db -- basedir =/usr/local/mysql -- datadir =/data0/dbdata/mysql/3306 -- user = mysql #/Usr/local/mysql/scripts/mysql_install_db -- basedir =/usr/local/my

MySQL installation package and decompress the installation package.Double-click the setup.exe file. next you only need to install the default configuration and click "next". by default, the installation information will be in the C: \ mysql directory.Next, you can enter "cmd" command = "in the search box and switch to the C: \ mysql \ bin directory at the command prompt, and enter the following command: mysqld.exe --console If the installation is successful, the above commands will output som

= 1/-DWITH_SSL = system/-DWITH_EMBEDDED_SERVER = 1/-DENABLED_LOCAL_INFILE = 1/-DWITH_INNOBASE_STORAGE_ENGINE = 1 # Make# Make install The percentage of progress can be seen in make and make install, which is better than configure.2. create configuration files that support multiple instances Go to the MySQL main directory# Cd/opt/mysql/ Delete the default data directory# Rm-rf data Create the required Directory# Mkdir etc tmp init. d run log binlogs data data2# Chown-R mysql: mysql tmp run i

Enable MySQL remote connection in Linux For security reasons, the root account can only be accessed locally, but the root remote access permission may be required during development. The basic steps are as follows: 1. log on to mysql and grant remote access permissions to the root user. run the following command: Mysql> grant all privileges on *. * TO root @ "%" identified by "root "; Mysql> flush privileges; In the first sentence, "%" indicates that any host can be remotely logged on to th

Mysql database basic operation environment 3: msyql version 5.0, windows OS Mysqladmin command to change password 034039-> 123456 C:/Users/ASUS>mysqladmin -u root -p034039 password 123456C:/Users/ASUS>mysql -u root -p123456Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 32Server version: 5.0.96-community-nt MySQL Community Edition (GPL)Copyright (c) 2000, 2011, Oracle

not grant permissions. This creates a user and allows him to log on, but does not allow other operations, such as update/select. Authorization level MySQL has five levels of permissions: Global Level) Database Level) Table Level) Column Level) Subroutine Level) Permission effective When the MySQL database server is started and the GRANT and REVOKE statements are used, the server automatically reads the grant table. You can also manually modify them. When you update them manually, the MySQL serv

the Ldconfig command, and qualifies the text to be displayed in a similar manner: libmysqlclient.so.6 = libmysqlclient.so.6.0.0. 7. echo "/usr/local/mysql/bin/safe_mysqld >/dev/null " >>/etc/rc.d/rc.local Add the MySQL boot command to the/etc/rc.d/rc.local file so that MySQL will run automatically each time you start Linux. 8../scripts/mysql_install_db Initializes the database. 9./usr/local/mysql/bin/safe_mysqld >/dev/null To start the MySQL server as a daemon, the MySQL server must be started

number of directories in the PATH environment variable and hides the MySQL utility program that you do not want other people to run (for example, the Mysqladmin command). Another method is to put the command path= "$PATH:/usr/local/mysql/bin" in the/etc/profile file. Both of these methods can be used. Ln-s\. /usr/local/mysql/bin/mysqlshow \ /usr/bin/mysqlshow The directive is for the general user to be able to run the mysqlshow command. 2.4 Testing

MySQL-Win32 has proved its stability. This version of MySQL has the same features as the corresponding Unix version, except the following:Win95 and threadWin95 loses about 200 bytes of memory for each thread creation. Therefore, if you have many connections, you should not run mysqld IN Win95 for a long time, because every connection of MySQL creates a new thread! WinNT and Win98 cannot tolerate this bug. Blocking read) MySQL uses one blocking read for each connection, which means that a connect

The following figure shows how to modify the mysql password: mysqladmin-u username-p old password when the new password is changed. commandsendwith; org. yourMySQLconnectionidis10Serverversion: 5.5.2 The following figure shows how to change the mysql password: mysqladmin-u username-p old password when the new password is changed, Enter password: Welcome to the MySQL monitor. commands end with; or g. your My

Today, I used the green version of mysql. the root password is blank during login. I have found several solutions on the Internet. I personally think the two methods are the most convenient and quick: the first one is: run the mysqladmin command to modify the password ----------- mysqladmin-uroot-ppasswordnewpassword. Enter the root password and press Enter. Today, I used the green version of mysql. the ro

status:Mysql> Show StatusCopy CodeExit Client:mysql> ExitView current MySQL max connections: Mysqladmin-uusername-ppassword variablesMethod Three:For example, the manual compilation version of the MySQL 5.0.33 below CentOS 4.4 illustrates:Vi/usr/local/mysql/bin/mysqld_safeCopy CodeFind Safe_mysqld edit it, find the two lines that mysqld started, and add the following parameters:-O max_connections=1500Copy CodeThe specific point is the following posit