1, MySQL installation after the password can not be landed problem Then you need to go into the/etc/mysql directory and check the username and password inside, and then sudo vim debian.cnf Use the username and password in this file to enter MySQL, if the username in debian.cnf is debian-sys-maint, then: Mysql-u debian-sys-maint-p Press ENTER, when you need to enter a password, copy the password in the DEBIAN.CNF (do not manually input, because error prone).A prompt such as mysql> appears in the
Configuration file Fragment650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/88/35/wKioL1fr9drR-MAdAADQ8rrj00k930.jpg-wh_500x0-wm_3 -wmp_4-s_2941404902.jpg "title=" zabbix1.jpg "alt=" Wkiol1fr9drr-madaadq8rrj00k930.jpg-wh_50 "/>Start Zabbix_proxy failure, look at the log, always go to even localhost, how to change all the same, scary ah650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/88/39/wKiom1fr9f3S5xWZAAFa4I275LE488.jpg-wh_500x0-wm_3 -wmp_4-s_2418975122.jpg "title=" zabbix
First, the method:Log on to MySQL to install the MySQL machine,Perform:GRANT All Privileges on *. * to ' Root '@ '%' by'password001! ' with GRANT OPTION;Refresh permissions:FLUSH PrivilegesSecond, the method:Refer to the following: http://www.cnblogs.com/hyzhou/archive/2011/12/06/2278236.htmlMethod one, log in to MySQL locally, change the "MySQL" Database in the "User"Host" in the table, change "localhost" to "%"#mysql-U root-Prootmysql> UseMysql;mysql>Update User SetHost= '%' where User = '
;grant all privileges on * * to ' liuhui ' @ '% ' identified by ' Liuhui '; Description: Set the specified user name to Liuhui, password to Liuhui, and access to all databases * 5, set specify accessible host permissions Copy CodeThe code is as follows:Mysql>grant all privileges on * * to ' liuhui ' @ ' 10.2.1.11 '; Description: Set the specified user name Liuhu
Set the root permission for mysql remote connection bitsCN.com
You may have encountered this problem when remotely connecting to mysql. the root user cannot connect to mysql remotely, but can only connect locally and reject the connection.
You must create a database account that allows remote logon to perform database operations.
The method is as follows:
By defa
). ======================================================================= My approach is this: ======================================================================= To modify the Remote Desktop port number of the target machine: 1. Open the Registration form [HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Terminal Server\wds\rdpwd\tds\tcp], Modify the value of the right portnumber (the default value is 3389) to 6006.2. Open the registry again
Set up rsync remote file synchronization service under Centos6.5
I. Server Installation
1. System Environment
Server: centos6.5 Factory environment (set by default during system installation), IP: 192.168.10.185
Client: Remote logon terminal xshell5 or securecrt (please check the installation and usage ),
IP: 192.168.1
MARIADBMysql_secure_installationFirewall-cmd--permanent--add-service MySQLSystemctl Restart Firewalld.serviceIptables-l-n|grep 3306installing MySQLCentos7 default does not have MySQL yum source, need to download again:
1. Download the MySQL repo source$ wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm2. Install MYSQL-COMMUNITY-RELEASE-EL7-5.NOARCH.RPM Package$ sudo rpm-ivh mysql-community-release-el7-5.noarch.rpm3. Install MySQL$ sudo yum install Mysql-server4. Reset Passwor
In order to further improve the security of database access, in the controlled end of 2006-5-28 v3
User area database management increase [set IP for remote Access database] Features
Users can set the IP address of the remote Access database themselves.
Network management can be on the server, using the Extraterres
Tags: Log configuration binding string existence partial comment open permissionThis article records remote access to the MySQL database set up under Ubuntu version 16.04.First step: Modify the port bindings for the configuration fileThe Open directory may be slightly different depending on the version of MySQL, you can first try to open/etc/mysql/my.cnf This configuration file, if the file does not exist o
May be IP is not set good
Problem: MySQL permissions are set correctly, but still cannot be accessed remotely. The 3306 port was not opened by Telnet.
Analysis: MySQL defaults to bind only 127.0.0.1, that is, only on this computer to access Port 3306.
Workaround: Locate the MySQL profile, search for "bind-address" and find this line:
bind-address = 127.0.0.1 Add a # in front, comment out this line, save
' indicates the logged-in user, '% ' means all computers can be connected, can also set an IP address to run the connection, ' Huaxia 'Represents a password).then execute flush privileges; command Refresh execution650) this.width=650; "title=" 4.png "src=" Http://s2.51cto.com/wyfs02/M00/7C/EF/wKioL1bc87OjeefDAAAeCPpJLUE620.png " alt= "Wkiol1bc87ojeefdaaaecppjlue620.png"/>Three. Connect using the connection tool such as NavicatRemember to shut down th
1. generate the public key and key verdana @ hostname :~ $ Ssh-keygen-trsaGeneratingpublic/privatersakeypair. Enterfileinwhichtosavethekey (/home/verdana/. ssh/id_rsa): Enterpassphr
1. generate the public key and key
Verdana @ hostname :~ $ Ssh-keygen-t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/verdana/. ssh/id_rsa ):
Enter passphrase (empty for no passphrase ):
Enter same passphrase again:
Your identification has been saved in/home/verdana/. ssh/id_r
immediately. Every time you want to view the content in mysql, you also need to log on to guest and view it through the command line. Some students raised their hands and said that you can install phpmyadmin and view it through a browser. This is indeed a good method, but it is not a phper for me, I always feel that it is cumbersome to install a php environment to view mysql. In fact, there are still some elegant solutions, that is, using the mysql GUI client to directly view the mysql In the g
Set up VNC Remote Desktop Connection in Linux to install Oracle11GPreface:1. Check whether the VNC service has been installed on the server. The command to check whether the VNC is installed on the server is as follows:[Root @ powerlong5 rpms] # ps-eaf | grep vnc2. If vnc is not installed, run the following command to install it:Yum install tigervnc-server-y3. The following is the configuration problem afte
lnmp.orgInstallation of the environment,Install Redis,Only need the directory,Enter the directory after LNMP decompression, execute:./addons.sh Install RedisCan.Then turn on Redis.Modify the configuration file. /usr/local/redis/etc/redis.confProtected-mode to set to NoDaemonize Yes# bind 127.0.0.1Requirepass ******Turn on the run.CD /usr/local/redis/bin./redis-server /usr/local/redis/etc/redis.confIn the config.php of THINKPHP5.Redis Cache' Redis ' =
Specific methods
1. First of all, we need to return to the traditional desktop location of the WIN8 computer, we also press the keyboard win+r shortcut keys to open the computer's running window, in the Open Run window, we enter regedit and click Enter.
2. In the Open Registry Editor window, we are in [hkey_local_machinesystemcurrentcontrolsetcontrolterminal serverwdsrdpwdtdstcp], Then double-click the portnumber in the right window and change to the port number you want in the decimal state,
Label:has been single-person development so did not consider this aspect, to the new company to do co-development, so to set up, and then began to engage inHere's a list of the procedures:1) Because of the use of the cloud server, so the above are configured, directly configure the MySQL command line input password can enter the2) This step is to see a list of users of the database3) Then use MySQL database changed is to modify databases with select H
, please first confirm whether the firewall is turned on, centos7 default is firewall, we can stop and prohibit the use of it, and then start our familiar iptables, so good! Note: MySQL clients are required to install MySQL client. View firewalls directly using Iptables-lService iptables Stop shutting down the firewallService iptables Start/restart turn on or restartOriginal address: http://my.oschina.net/fhd/blog/383847or http://www.mamicode.com/info-detail-503994.html.Install MySQL using yum
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.