Ubuntu FAQs Configuration

When you do a project, the VMware virtual machine installs Ubuntu 14.04.4来 as the MySQL database server, the host is Windows 10 Enterprise Edition. There are a number of common problems to record here:

First, the system configuration chapter.

1, why win can ping through Ubuntu, but Ubuntu can not ping through win?

Make sure the file and printer Sharing is checked in the Control Panel.

　　

If you do not have the option, make sure that:

Control Panel-Programs and features-enable and disable Windows features in print and file services are checked:

　　

2. How do I upload and download files via ssh?

　　A. downloading files from the server
SCP [Email Protected]:/path/filename

For example SCP [email protected]:/var/www/test.txt to download the/var/www/test.txt file on 192.168.0.101 to the current directory

b, upload local files to the server
scp/path/filename [Email Protected]:/path

For example scp/var/www/test.php [email protected]:/var/www/the test.php file in the native/var/www/directory to 192.168.0.101 directory on this server

C. Download the entire directory from the server
scp-r [Email protected]:/var/www/local_dir/

Example: scp-r [email protected]:/var/www/test/var/www/

D. upload directory to server
Scp-r Local_dir [Email protected]:remote_dir
For example: scp-r test [email protected]:/var/www/to upload the test directory under the current directory to the/var/www/directory of the server.

2. How do I change the source in Ubuntu text mode?

Create a home environment variable under win, creating the source Sources.list in the folder. Generate source can be see, https://lug.ustc.edu.cn/repogen/

Upload sources.list to Ubuntu's user home directory:

SCP ~/sources.list {username}@{ip}:/home/{username}/

Backup sources.list:

sudo mv/etc/apt/sources.list/etc/apt/sources.list.bak

Replace:

sudo mv ~/sources.list/etc/apt/sources.list

Change permissions and owning groups:

sudo chown 644/etc/apt/sources.list

sudo chown root/etc/apt/sources.list

sudo chgrp root/etc/apt/sources.list

　　Second, MySQL (5.5) article

1. Installation

sudo apt-get install Mysql-server

2. View the Code

　　Show variables like ' character% ';

3. Set the encoding

　Add Default-character-set=utf8 in the [Client] field

Add Character-set-server=utf8 in [mysqld] field

Add Default-character-set=utf8 in the [MySQL] field

4. Allow LAN access:

　　Grant all privileges on * * to [email protected]"%" identified by ' 123 ' with gran   t option; (here to allow root users to telnet)

Flush privileges;

Modify/ETC/MYSQL/MY.CNF, comment out bind-address = 127.0.0.1

Restart MySQL

Ubuntu FAQs Configuration