After installing MySQL at night (System: Deepin WINXPSP2, MySQL version: 5.1.32), the default data storage path is configured with MySQL's own configuration tool: C:/Documents and Settings/all users/ Application Data/mysql/mysql Server 5.1/data/.
Today, when you browse an ASP. NET project, you are prompted with the following error:Could not load file or assembly ' MySql.Web.v20, version=6.9.4.0, culture=neutral, publickeytoken=c5687fc88969c44d ' or one of its dependenciesThe following
First, the service-side deployment# Install the extension source, and then install the service dependency package [[email protected] ~]# yum install -y httpd mysql mysql-libs php php-mysql mysql-server php-bcmath php-gd php-mbstring# Install
(1) Open PHP security mode
PHP's Safe mode is a very important embedded security mechanism that can control functions in PHP, such as System (),At the same time, a lot of file operation functions are controlled by permissions, also do not allow
CMD run the following command:
NET stop
NET start
Note: usually defaults to: MySQL
That
net stop MySQL
net start MySQL
Note:
How to view service names:
On the desktop-> right-click "Computer"-> choose "Management"-> choose "Service and
First recruit, the start and stop of MySQL service
net stop MySQL
net start MySQL
Second recruit, login MySQL
The syntax is as follows: Mysql-u user name-p user Password
Type the command mysql-uroot-p, enter the password to prompt you, enter 123
First recruit, the start and stop of MySQL service
net stop MySQL
net start MySQL
Second recruit, login MySQL
The syntax is as follows: Mysql-u user name-p user Password
Type the command mysql-uroot-p, enter the password to prompt you, enter 123
In order to meet the requirements of the site's high load, when the Apache parameters are adjusted to find that the process often consumes too much memory caused by the machine. After continuous optimization and modification of parameter combination,
Because to debug the relationship of the program, from the background to modify the MySQL settings, set tojoin_buffer_size=512kAfter the result is saved MySQL cannot connect immediately, reboot Lu-restart,mysql-restart cannot connect.
Operation
For the previous installation of MySQL notes are summarized, to share with you.
version: Mysql-5.7.16-winx64Platform: Windows 7 x64
1, into the MySQL home directory (recommended to move it to the C or D disk root directory, and renamed to MySQL)2.
After the rebirth of their own web site backup data used a very soil method, used to winrar batch processing backup function, hope to some friends can use.
My server configuration is WINDOWS2003+IIS+PHP+MYSQL5.
First the server needs to install a
Asp.net|mysql|web recently prepared to use mysql+.net for development, read three article:
1 MySQL and asp.net cooperate more powerful;
2 choose MySQL or SQL Server;
3 The use of MySQL and. Net2.0.
MySQL is more powerful with asp.net
Due to
1. Get the MySQL program. The appropriate version of MySQL can be downloaded from the official Oracle Web site. I got the MySQL file for: mysql-5.5.29-win32.zip;
2. Unzip the compressed package to the desired directory. Here I extract to D:devmysql
Tip: If you install MySQL service name is not MySQL, please use a text editor to open the bat file, batch replacement file MySQL.
Mysql.bat Program Source Code
Usage: Save the following file copy for Mysql.bat Direct operation, if your server
mysql| Access | data | Database Summary
As a small relational database, MySQL has won the favor of a large number of small and medium-sized enterprises and individual users with the features of low price, powerful function, decent speed and open
1. Login official website http://dev.mysql.com/downloads/mysql/Download the installation package (MySQL installation package is divided into two types, one is MSI format, one is the zip format)Note: MSI format is not described here, just next can be
Installing the configuration MySQL 5.7Open MySQL Website:https://www.mysql.com/Click Downloads, and then select commuity Select MySQL Community server to select the corresponding system version of the installation package. Here choose mysql5.7 Win 64
The characteristics of the database: structured, no harm, no duplication;Second, the database advantages: According to a certain data model organization, description and storage; can be shared for a variety of users, redundancy is small, save
First trick, start and stop of MySQL servicenet stop MySQLnet start MySQLSecond move, login MySQLThe syntax is as follows: Mysql-u user name-p user PasswordType the command mysql-uroot-p, enter the password after entering, enter 12345, and then
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.