Solution:
1. Change the table.
It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to MySQL on the computer of localhost, and change the "host" entry in the "user" table in the "
Modify the permission Method for mysql to allow access to the host. mysql allows access to the host.
Enable mysql Remote Access Permissions
By default, mysql users do not have the permission for remote access. Therefore, when the program is not on
Zhou has not installed a Linux Virtual Machine for fun. The final effect is as follows,
1) The host is win7
2) install a Linux system (Ubuntu selected) and WINXP on the guest Machine
3) directories can be shared between hosts and guest machines;
4)
**************************************** ******************
The first part is to build a multi-mysql service on a server.
**************************************** ******************
I. xuyan
There is a mysqld_multi command in Mysql that can be used
After I deleted the original mysql4.0 file in s9, I installed a new mysql5.0 file. During the startup process, I reported an error and failed to start the file. I checked the old post in the group and did not provide a specific description.
After I
Run multiple MySQL services on the same machine
Run multiple MySQL services on the same machine
**************************************** ******************
The first part is to build a multi-mysql service on a server.
*****************************
1. download MySql
1. download MySql
Open http://www.mysql.com/downloads/mysql/#downloads download in browser
My downloaded version is Red Hat 5 version of http://www.mysql.com/downloads/mirror.php? Id = 407552
Upload the file to the server, or
Modify the permission that mysql allows the host to access. mysql allows the host permission.
Enable mysql Remote Access PermissionsBy default, mysql users do not have the permission for remote access. Therefore, when the program is not on the same
Install MySQL1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-5.1.7-0.i386.rpm
To download the above two RPM files, locate the "server" and "client programs" items and find the items
Records in the error log:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. host' doesn' t exist
I posted a post. I only saw it, but no one replied. I can only solve the problem by myself. Can I help myself... You don't have
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.