MySQL ????????????????????????????????????, Mysql
???????????????????????????????????????? ??
???????????????? :
Mysql> grant all privileges on wubx. * ?? Wubx '@' 172. 16.100.185 ?? Identified ?? Fd52! Wubx ??, ';
Query OK, 0 rows affected (0.00 sec)
Mysql> quit;
# Mysql-h 172.16.100.185-u wubx-pfd52! Wubx ??,
-Bash :! Wubx @,: event not found
???????????????????????????????????????? ???????????????????? Navicat ??????????????????????????????????????
???????????????????????????????????? PHP ????????
???????????????? :
$ Link = mysql_connect ('2017. 16.100.185 ??, 'Wubx', 'fd52! Wubx ??, ');
If (! Link ){
Die (?? Cocould not connect: '. mysql_error ());
}
Echo ?? Connected successfully '; mysql_close ($ link );
?>
# Php testdb. php
Connected successfully
??????????????????????
PHP ???????? OK ????????
What is mysql?
Application in Small and Medium websites on the Internet. Because of its small size, fast speed, and low total cost of ownership, especially the open source code, many small and medium websites have chosen MySQL as their website database to reduce their total cost of ownership.
This may be a bit professional. Simply put, it is a data storage warehouse that can store text, images, and other information to add, delete, modify, and query data operations, is the lifeblood of website operation.
PHP is a language for program development. Generally, it is used on websites more often. For website development, databases are needed. Here, MYSQL is the first choice, because many of us have tested it, PHP and MYSQL work together with each other in terms of operational efficiency, which is the first choice for development of small and medium-sized websites. They also work with APAPHE and LINUX, which are called LAMP by industry insiders.
If you want to learn more, you can go to a professional website to learn more. For example, LAMP brothers and Kang shengchuangxiang are all well-known PHP development training institutions with rich content.
What are the differences between MYSQL and SQL?
SQL Server xxxx is a Microsoft DBMS (DataBase Manager System)
MySQL was initially an open-source organization project. at that time, the functionality was sufficient for General small business users. due to the good copyright protection in foreign countries, it seems that there is no pirated software in China, and database software is very expensive, therefore, this type of software has poor students and small companies that want to save costs. naturally, it appears.
These two are relational databases. I think the difference is subtle, such as the storage capacity, some key algorithms, the indexing speed, and a lot. I am not clear about them in depth, ask experts!
My feeling:
1. SQL Server is better than MySQL in terms of stability
2. SQL Server is supported by many vendors and supported by many languages. Various drivers are also easy to get.
SQL and MySql belong to the same relational database management system and strive to unify functions, so they have the same basic functions.