6.8 Other topicsThis section includes several topics that are not fully suited to any of the sections in the development of this chapter from CLIENT1 to CLIENT5:After using the result set metadata to help verify that the data is appropriate for
1 Login with MySQL client
2 Select Database
mysql>use test
3 What stored procedures are queried for the current database
mysql>show procedure status where Db='test'
4 Create a simple stored procedure
mysql>create procedure hi() select 'hello';
Operating system: DEBIAN Linux 3.1
MySQL database version: 5.0.27
(1) Login with system root Authority
(2) Stop MySQL server:Mysql.server stop
(3) Skip authorization form to execute MySQL server:Mysqld_safe--skip-grant-tables--skip-networking
You cannot back up your data at any time, but when your data is lost, or if the files in the database directory are corrupted, you can only restore the files that you have backed up, and the data that is inserted or updated after that is powerless.
mysql| Data | Data Directory
MySQL Data directory structure
Blue Forest http://www.lslnet.com May 28, 2000 10:40
Author: Yan Zi
Conceptually, most relational database systems are similar: They have a series of database components, each
When you connect to a MySQL server, you should usually use a password. The password is not transmitted on the connection with clear text. All other information is transmitted as text that can be read by anyone. If you're worried about this, you can
If you never set the root user password for MySQL, the server does not need a password to connect as root. However, it is recommended that you set a password for each account.
If you have previously set the root user password, but have forgotten
mysql| user rights You can have 2 different ways to add users: by using the grant statement or by directly manipulating the MySQL authorization table. The better approach is to use the GRANT statement because they are more concise and seem to have
Once you have set up a password file for the MySQL instance manager and im running, you can connect to it. You can use the MySQL client tool to connect through the standard MySQL API. The following is a list and example of commands that the MySQL
mysql| Data | Database summary
In this chapter, we will introduce the scripting language for this server side of PHP. We will see that this language can well support communication with the MySQL database.
(2002-08-29-14:10:52)
--------------------
Although a lot of online, or here to record their own installation process, and some experience, do not have to install and then everywhere to find.
First say MySQL, because he can say completely independent and Apache, PHP installation is not
mysql|window| problem using phpmyadmin times wrong:
Client does not support authentication protocol requested
by server; Consider upgrading MySQL client
The official statement is
MySQL 4.1 and up uses the authentication protocol based on a
MySQL Author: jeanx
[Solve the problem and share it with us]
Garbled problem:
The default character settings are shown in the following illustration in the MySQL4.1 installation process
If your server does not have the option to default to GB, it
Most server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behavior. However, most people are not aware that standard
Open the Slave log today and find a bunch of bugs all of this:
[ERROR] Slave:error ' Character set ' #28 ' is not a compiled Character set and isn't specified in '/usr/local/mysql/share/mysq L/charsets/index.xml ' file ' on query.
I wrote the
First of all, the following description is limited to the win system other systems I have not tried, Mysql since 4.1.1 modified the user password format, from 16 bits to 41 bits, a new authentication method, but 4.1 of the previous client protocol
MySQL field type
1. int[(M)]
Normal size integer type
2. double[(m,d)] [Zerofill]
Normal size (double precision) floating-point number type
3. DATE
Date type. The scope of support is ' 1000-01-01 ' to ' 9999-12-31 '. MySQL displays date values
Many server administrators know that the MySQL database management system (RDBMS) is a highly flexible software block with a wide range of startup options that can be used to modify related behavior. However, most people are not aware that standard
Getting Started: Detailed Windows PHP5+APACHE+MYSQ full configuration
After a period of frenzied PHP programming, the configuration of PHP under the Windows platform is a deep feeling, at first I used a button to install the fool bag, but consider
MySQL supports one-way, asynchronous replication, in which one server acts as the primary server and one or more other servers act as the server. The master server writes the update to the binary log file and maintains an index of the log file to
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.