Start from the beginning, take it slow, today's logbook

Source: Internet
Author: User
Tags mysql command line

Today, starting work, although the salary is lower, but I think I will never be this way

Work content, first set up the environment, here need to understand, what this website uses, JDK,MYSQL,IE8

Install MySQL, there is a problem here, is to localhost can, but with their own native IP address login does not go in, prompted 1130 error (),

The workaround is to use the localhost connection after the MySQL command line interface, enter the following code

Mysql> Grant USAGE on * * to ' ROOT ' @ '% ' identified by ' 123 ' with GRANT OPTION;
Query OK, 0 rows affected

Mysql>

And then you see the user

Then edit the user to have all the permissions.

After that, the imported SQL file is larger, you need to add a piece of code in the My.ini file (alternate)

Max_allowed_packet = 200M
interactive_timeout=28800000
wait_timeout=28800000

Restart MySQL Service

Start from the beginning, take it slow, today's logbook

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.