how to remotely connect to ubuntu

Mysql>grantselect,insert,update,delete on [db_name].* to [Username]@[ipadd] identified by ' [Password] '; [Username]: User code for remote login [Db_name]: Indicates the database to be open to users [Password]: User password for remote login [IPADD]:IP address or IP reverse DNS Name, the contents of this example must be filled in ' 60-248-32-13.hinet-ip.hinet.net ', the package is enclosed in quotation marks (') Brackets "" Do not enter when using the command. Over here: I am using virtual ma

first, connect to the remote database:1. Display PasswordFor example: MySQL connection remote Database (192.168.5.116), port "3306", username "root", password "123456"c:/>mysql-h 192.168.5.116-p 3306-u root-p123456 2. Hidden passwordsuch as: MySQL connection to the local database, the user named "root",c:/>mysql-h localhost-u root-pEnter Password:Second, configure MySQL to allow remote linksby default, the MySQL account is not allowed to log on

If you need to remotely connect to a SQL Server server, what should you do? The following will teach you the solution for remote connection to the SQL Server server for your reference. A look at ping server IP can ping through. This actually looks at whether the physical connection to the remote SQL Server 2000 Server exists. If not, check the network to see the configuration, and, of course, make sure th

|* +-----------+------------------+* | % | Root |* | localhost | Debian-sys-maint |* | localhost | mysql.session |* | localhost | Mysql.sys |* +-----------+------------------+* Tips: Note this time to save the exit (flush privileges;)* Then restart MySQL (/etc/init.d/mysql restart/service mysql restart)**/ //Above this is a modification to be made on the server /*** This time to connect MySQL if still unsuccessful, the server will be reported to rej

Hadoop is mainly deployed and applied in the Linux environment, but the current public's self-knowledge capabilities are limited, and the work environment cannot be completely transferred to the Linux environment (of course, there is a little bit of selfishness, it's really a bit difficult to use so many easy-to-use programs in Windows in Linux-for example, quickplay, O (always _ success) O ~), So I tried to use eclipse to remotely

Test-user; Note: This action only clears the user's authorization rights for TEST-DB, but this "test-user" user still exists. Finally clear the user from the user table: DELETE from user WHERE user= "Test-user"; Overload Authorization Table: FLUSH privileges; Exit MySQL database: Exit five, MySQL permissions detailed classification: Global Administrative permissions: file: Read and write files on the MySQL server. PROCESS: Displays or kills service threads belonging to other users. RELOAD: Over

Tags: learn res close ping conf cannot remote UI information1. See if the road is smoothPing the server's IP address (Windows)Command: IP Display Network informationIP Address = = = IP A displays network card informationIP address show eth0 ===ip a s eth0 display information for a NIC2. Is there any robbery?Whether the firewall and SELinux are off3. See if someone is providing servicesWhether the server's port 22 is turned onWindows:1#telnet 10.0.0.200 22Linux:Ss-lntup #显示系统中已经开启的端口Ss-lntup |gre

I have recommended how to set up the PPTP VPN service in the article "VPs initial experience and self-built VPN service". This article has made some modifications and supplements based on the original article, and added"How to connect to pptp vpn on Linux. The running environment involved in this article: the remote server is configured with low xen VPs on vpslink (note that pptp vpn cannot be installed in openvz VPs), and the Linux system is

1. See if the/ETC/MYSQL/MY.CNF configuration file only allows local connectionsNote configuration: #bind-address = 127.0.0.1, restart MySQL Server2, Firewall (I use iptables) prohibit 3306 port accessAdd the 3306 port to the/etc/sysconfig/iptables configuration file, and then restart the firewall by adding the following:-A input-m state--state new-m tcp-p TCP--dport 3306 -j ACCEPT3. mysql does not grant the appropriate permissionsAuthorized user username use password to

Tags: Linux secret key remote connection Linuxconnect to Linux remotely using PuttyFirst go to download puttyAs far as possible to download the official website, the official version of the Puttygen, we use the secret key after the use of Download this version 32 bit on the line, 32 bit on 64-bit system uptime Open Putty This location enter the IP address of the server that needs to be remote If you do not know the server IP needs to go to nati

and font you are accustomed to650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M01/A7/31/wKioL1njD5qSJGxJAAEtNYA075Y328.jpg "title=" 3.jpg "alt=" Wkiol1njd5qsjgxjaaetnya075y328.jpg "/>650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M02/08/7D/wKiom1njEnqChMtDAACNB220jsk156.jpg "title=" 6.jpg "Width=" 467 "height=" 570 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:467px;height:570px; "alt=" Wkiom1njenqchmtdaacnb220jsk156.jpg "/>D. Click on the left translation and modify the r

If you want to connect to your mysql instance, this error occurs: Copy codeThe Code is as follows: ERROR 1130: Host '192. 168.1.3 'is not allowed to connect to this MySQL server 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 l

Recently, a MySQL 5.0 is installed on Ubuntu. Because phpMyAdmin must also be installed, we plan to directly use the remote management tool Navicat for MySQL to connect. Create a data table through the mysql Command Line in Ubuntu and assign permissions: Copy codeThe Code is as follows:Grant all on testdb. * TO usera identified by 'passwd' Then restart the loa

|+ -------------- + ------ + --------------------------------------------- +3 rows in set (0.00 sec) In this way, the machine can remotely access MySql on the machine with the username root Password root. 3. remote connection (Table change) The Code is as follows: Use mysql;Update user set host = '%' where user = 'root '; In this way, you can access Mysql through the root user at the remote end. Another method