Mysql database my. ini configuration file

  Mysqld Program-directory and file Reference Basedir = path uses the given directory as the root directory (installation directory ).   Character-sets-dir = path indicates the directory where the character set is stored.   Datadir = path reads

Mysql basic Import and Export commands

  1. Export the entire database   Mysqldump-u username-p Database Name> exported file name   Mysqldump-u wcnc-p smgp_rj_wcnc> wcnc. SQL   2. Export a table   Mysqldump-u user name-p database name Table Name> exported file name   Mysqldump-u wcnc-p

The mysql service of wamp5 cannot be started.

  Recently, due to the company's needs, I began to learn php... It feels a little simple .. It may be a bit of java basics .. But not yet .. It's just a simple test. The problem also occurs when installing the tool. I have summarized three points.

Quick start to close the MySQL service batch code

  Save the following code in the txt text and change the extension to. bat. When you need to start the mysql service, double-click the. bat file. Double-click it again when it is disabled. View plain @ Echo off For/f "skip = 3 tokens = 4" % I

Mysql Import and Export databases, add and modify field commands

  Mysql export database table contains data commands: Mysqldump-uroot-proot abc>/var/abc. SQL; (Mysql user name: root Password root database: abc export to:/var/abc. SQL) Mysql export database tables do not contain data commands:

Configuration notes for master-slave replication between mysql instances

MySQL-master1: 192.168.72.128 MySQL-master2: 192.168.72.129 OS Version: CentOS 5.4MySQL version: 5.5.9 (the master and slave servers with master-slave replication have the same mysql version or the master version is later than the slave version) 1.

Mysql reports Access denied for user when using lock without the LOCK tables permission

An error is reported when a common user backs up a mysql database. Mysql reports Access denied for user 'dbuser' @ 'localhost' to database 'db' when using lock tables if you do not have the lock tables permission The main reason is that the user

Differences between mysql dumpfile and outfile Functions

I always thought that the two functions serve the same purpose. Some differences have been found through simple tests. Admin Mysql> select * from admin; + ----- + ----------- + --------- + | Uid | name | pass | + ---- + ------------ + --------- + | 1

Impact of type conversion on MySQL index selection

I encountered several cases where MySQL did not use the expected index. After reading some documents, I found that the impact of MySQL type conversion on index selection is not small. For example, there is a MySQL table: Create table 'indextest

Weird mysql latin1 Encoding

Mysql latin1 is not equal to the standard latin1 (iso-8859-1) and cp1252, 0x80-0x9f characters more than the iso-8859-1, than cp1252 0x81, 0x8d, 0x8f, 0x90, 0x9d has a total of five

Handler_read _ * of MySQL _*

In MySQL, we generally use show status to query the server STATUS. The syntax is generally as follows: SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] After executing the command, you will see a lot of content, some of which are Handler_

One of the solutions to the "Communications link failure..." error when remotely connecting to the mysql database

Today, when connecting to mysql with myEclipse, the message "Communications link failure, Last packet sent to the server was 0 MS ago." error interface is shown in:  Myeclipse error prompt pageCheck that the remote server can be pinged on the local

Garbled MySql in Redhat5

I installed redhat on the Virtual Machine and installed the mysql database. I accessed the database locally using java and directly accessed it using jdbc. Later, I found that there was a garbled problem when the database Stored Chinese characters,

Mysql Stored Procedure

1. create a stored procedure 1. Basic Syntax: SQL code create procedure sp_name () begin ......... End 2. parameter transfer 2. call the Stored Procedure 1. basic Syntax: call sp_name () Note: The name of a stored procedure must be enclosed by

Solution to mysql failure caused by innodb failure during abnormal Shutdown

When the innodb instance is shut down abnormally, the mysql instance cannot be started due to an innodb fault. View the err log. InnoDB: Starting crash recovery. innoDB: Reading tablespace information from. ibd files... innoDB: Restoring possible

Implementation of time comparison in MySql

The unix_timestamp function for time comparison in MySql can accept a parameter or do not use a parameter. The return value is an unsigned integer. If the parameter is not used, it returns the number of seconds that have elapsed since 00:00:00,

Use Navicat for MySQL to import and export Databases

Recently, a problem was found during the migration of the customer's website. When exporting an SQL file, the customer's database encountered an error during import. At that time, we copied the database folder to the server in the data center.Have

Modify the character set and default storage engine of mysql

Modify mysql Character Set and default storage engine 1. modify mysql character Set mysql Database Current character Set mysql> show variables like 'character % '; + metrics + | Variable_name | Value | + metrics + | character_set_client | latin1 |

Create an account and Set permissions for mysql in Linux

In Linux, mysql creates accounts and permission settings. 1. permission granting Description: mysql is deployed on server A, and host B on the Intranet connects to server A through client tools for database operations, server A needs to grant host B

MySQL audit plug-in installation instructions

The purpose of the MySQL audit plug-in installation instructions is to help developers and DBAs install and use the MySQL audit plug-in, and to have a more comprehensive understanding of audit usage and audit granularity. This article describes the

Total Pages: 3233 1 .... 1682 1683 1684 1685 1686 .... 3233 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.