1. Go to MySQL and create a new user root with the password root.:
Format: grant permission on database name. Table name to user @ login host identified by "User Password ";Grant select, update, insert, delete on *. * To root@192.168.1.12
Common commands:
Show databases; show all databases
Use pdns; select the pdns Library
Show tables; view all table names in the database
Select * From domains; query the content in the domians table
Drop table domains; Delete the domains
Keywords: Install the latest Apache + PHP + MySQL guide in Windows
Install the latest Apache + PHP + MySQL guide in Windows
1. installation environmentThe latest versions of Windows XP, Apache, PHP, and MySQL are available on the official
1. edit/etc/My. CNF file, add "default-character-set = utf8" under "[client]" 2. edit/etc/My. CNF file, add "default-character-set = utf8" under "[mysqld]" 3. restart MySQL service # sudo/etc/init. d/mysqld restart * view the system character
Linux (Ubuntu platform)JavaConnect to the MySQL database through JDBC, which is similar to that on the Windows platform. The procedure is as follows:
DownloadJDBC: mysql-connector-java-5.1.18.tar.gz
ExtractJDBC: Tar-ZxvfMysql-connector-java-5.1.1
(Note: The following addresses can only be downloaded using thunder. The following content is for reference only and there is no security configuration information)========================================================== ===========================
Recently, I have encountered remote MySQL permissions.
A few people have asked me the same question recently. I installed MySQL and then used Telnet IP 3306. The port then reported bhost '123. 0.0.1 'is not allowed to connect to this MySQL
1. Start
After MySQL is installed, run the following command to start MySql in the/etc/init. d directory.
[Root @ test1 init. d] #/etc/init. d/MySQL start
2. Stop/Usr/bin/mysqladmin-u root-P Shutdown
3. Automatic Start1) Check whether MySQL is
Add or modify the following in my. CNF:Code:[Client]Default-character-set = utf8[Mysqld]Default-character-set = utf8
We recommend that the encoding on the webpage be consistent with the encoding on the database. If both are utf8, set them to utf8.
For beginners, the most feared thing is environment configuration. I often encounter such a problem and waste a lot of time.
Today, I found an illustrated Apache + PHP + MySQL tutorial on the Internet. I installed and configured it step by step,
There are many MySQL GUI tools. The most common tools are the official MySQL GUI tools. However, this official tool can only be regarded as a regular tool in all aspects.
In comparison, MySQL-front is much better! Mysql-front is a small MySQL
MySQL cannot be started in XAMPP-control today. It prompts that MySQL service is not started. I really don't know what's going on at the moment, when the 360 security guard prompts me whether to set MYSQL as a system service or not, this problem
Use Database -- Use Database Current_date -- current date Current_time -- current time Show databases -- display a database Show tables -- display table Describe table name -- display table structure Load data local infile file path into
MySQL is a database software with excellent performance, and PHP is a powerful server-side scripting language. In the development of Shanxi Aluminum Factory website, I have used php4.0 + mysql3.23.38 to establish a variety of applications. Next, we
Creating a website on Windows is a good thing. Due to the popularity of open-source software, Apache + PHP + MySQL has become the first choice for many people. However, compared with the IIS provided by windows, for the first time users build
Typical configuration of Linux + Apache + MySQL + PHP
Debugging environment: redhat9.0 apache1.3.29 mysql3.23.58 php4.3.4
I will not talk about Linux installation. This is a basic skill.ArticleOther Linux systems similar to RedHat should also be
In the past, MySQL stored procedures did not have the concept of arrays, and there was little information on the Internet. Drop procedure if exists pro_deletelog; -- create procedure pro_deletelog (qualification varchar (100) -- Define the parameter
The database engine you can use depends on how MySQL is compiled during installation. To add a new engine, you must recompile MySQL. By default, MySQL supports three engines: isam, MyISAM, and heap. The other two types of InnoDB and Berkley (bdb)
Yesterday, I want to import a MB SQL file to the MySQL database. Because phpmyadmin supports a maximum of 8 Mb, IE will stop responding if the file is too large, so I used the following command as before:
Code
Code highlighting produced by
Document directory
B-Clone Database Table with all data
MySQL is a programming language based on C and C ++ later than mySQL 1995. ITA is the most commonly used open source database today, because of the great verstality applied online. MySQL
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