The code is as follows
Copy Code
Class MySQL {Public $sqlserver = ' localhost ';Public $sqluser = ' root ';Public $sqlpassword = ';Public $database; Public $last _query = '; Private $connection;Private $query _result; Public
This procedure includes three files
reg.html User Registers HTML pagereg.php PHP Processing codeconn.php Database Tutorial Connection file
reg.html Code
The code is as follows
Copy Code
php+ajax User Registration To
knows.nl bied free access to Particulieren,bedrijven Chinese Verenigingen on the river.
Aanmelden voor Eyne website geheel kostenloos Dietegen to meet with the newspaper Registratie Formulier.
DirectAdmin controlpanel,php and MYSQL,100MB, 1 of the
Add user
Native access Permissions:mysql> GRANT all privileges on *.* to ' username' @ ' localhost '
-> identified by ' password ' with GRANT OPTION;Remote access permission:mysql> GRANT all privileges in *.* to ' username ' @ '% '
-> identified
MySQL Workbench Not available
Previously used in the XAMPP MySQL components, the previous use of relatively simple, but only to import the database in the WEB directly after the use, did not find this component of the problem, today with MySQL
Query from Table A for all records that do not appear in table B for the associated field. Now two data tables have data probably about 25,000 records, b table relative a table less than 230 records, so to query a table more out of the record, the
Generally we use mysqldump to back up the MySQL database and upload it to other backup machines. If the database is large, it may be slow when the backup is transmitted, so we try to make the backup file smaller.When writing an automatic backup
Today due to accidental login MySQL server (the MySQL server is equipped with phpMyAdmin) to view the process (show processlist), I went to a large number of unauthorized users to connect to MySQL, the process results are as follows:
To add a user account to the MySQL users table:
Instead of adding a user record directly using the INSERT statement, you can use Insert to appear:
Error 1364 (HY000): Field ' ssl_cipher ' doesn ' t have a default value. However, the earlier MySQL
Mysqldump Backup command-uroot Root User-p123456 Password is 123456The database where the MyDB table resides MyDBMYTB the table that will be exported MYTB>/opt/mytb.sql Backup to Mytb.sql
Export the entire database
The code is as
Import 1G of data, but in how not to import, with the command line can be easily done. Use the MySQL source command to import larger files.
The code is as follows
Copy Code
Mysql>use dbtest;Mysql>set names
Let's Make a concrete demo:
1, first we want to login phpMyAdmin (as the current mainstream development language), do not do demo.
2, create a database, the following figure, in phpMyAdmin (as the current mainstream development language) right
Linux will need to modify/ETC/MY.CNF, under [mysqld] Add default-character-set = utf8,[client] under Add default-character-set = UTF8, in [MySQL] Add Default-character-set=utf8 in field
Realize:1. View the original code
code is as
1: First install apache: open the terminal (ctrl + Alt + t ),Enter the following command:Sudo apt-get install apache2To install,After installation, open your browser and enter localhost or http: // 127.0.0.1 in the address bar.If you see It works,
1. mysql cannot be started due to permission issues. In linux, permissions are very important.Permission problemsError messageWorld-writable config file '/opt/lampp/etc/my. cnf' is ignored[ERROR] Fatal error: Can't change to run as user 'mysql
Environment for ubuntu 12.04 desktop, mysql 5.6.12Mysql needs to be compiled using cmake. Therefore, install cmake first. The code is as follows:Copy code Sudo apt-get install cmake Configure compilation parameters: The code is as follows:Copy
Find the configuration fileI installed it through sudo apt-get install mysql. Mysql configuration file in/etc/mysql/my. cnfIf the file cannot be found, run sudo find/-iname '*. cnf' to find all cnf files.Modify configuration fileAdd under
Direct method:First, configure the iptables rules for the firewall under CentOS:# Vim/etc/sysconfig/iptablesAdd the following rules to the rule:-A input-m state-state NEW-m tcp-p tcp-dport 22-j ACCEPT-A input-m state-state NEW-m tcp-p tcp-dport 80-j
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