Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "the summary of common questions in MySQL database that beginners must know". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. About the problem of re-assigning the initial value of self-increasing fields?

ALTER TABLE tbl AUTO_INCREMENT = 1

two。 How to realize the function of self-growing field in mysql?

Create table abc (id int (10) not null auto_incremnet primary key)

Name varchar (10) not null

Address varchar (200) not null

Postcode char (6) not null

);

This creates a table whose id subsegment grows automatically.

You can also add such fields to a built table, as follows:

Alter table tb_name add id int (10) not null auto_increment first

Or

Alter table tb_name add id int (10) not null auto_increment

3. How to change the user's password in mysql?

A, under the mysql/bin/ directory

. / mysqladmin-u [user name such as: root]-p [old password, if no password is left blank] password [new password]

. / mysqladmin-uroot-p123456 password 456789

User name: root original password: 123456 New password: 456789

B. Enter mysql as root user

Mysql > use mysql

Mysql > update user set Password=password (newpassword) where User=root

Mysql > flush privileges

Pay attention to the case.

4. How to connect mysql remotely

(1) enter mysql and create a new user xuys:

Format: grant permission on name. Table name user @ Login Host identified by "user password"

Grant select,update,insert,delete on *. * to

Identified by "xuys1234"

View the results and execute:

Use

Select host,user,password from user

You can see that you already have the xuys user you just created in the user table. The host field indicates the host logged in, and its value can be either IP or hostname. Changing the value of the host field to% means that you can log in to the mysql server as a xuys user on any client machine. It is recommended to set it to% at the time of development.

Update user set host =% where user = xuys

(2) mysqladmin-uroot-ppwd reload

Mysqladmin-uroot-ppwd shutdown

(3) / mysqld_safe-- user=root &

Remember: any changes to the authorization table require re-reload, that is, step 3.

If you cannot connect from the client after the above three steps, do the following

Insert a record in the db table of my:

Use mysql

Insert into db values

(192.168.88.234)

Update db set host =% where user = xuys

Repeat steps 2 and 3 above.

This is the end of the summary of frequently asked questions in MySQL database that beginners must know. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.