下载
连无线wmsu_client 密码09876543
首先把这两个sql文件下载到本地
发现sql文件已经上传,并且有数据。
打开Xshell连接到10.191.1.2,可以先ftp工具找到目录/etc/mysql/my.cnf
/etc/mysql/mysql.conf.d/
cat mysqld.cnf
wmsu@wmsu:~$ cd /etc/mysql
wmsu@wmsu:/etc/mysql$ ls
conf.d debian.cnf debian-start my.cnf my.cnf.fallback mysql.cnf mysql.conf.d
wmsu@wmsu:/etc/mysql$ cat my.cnf
The MySQL database server configuration file.
You can copy this to one of:
- “/etc/mysql/my.cnf” to set global options,
- “~/.my.cnf” to set user-specific options.
One can use all long options that the program supports.
Run program with --help to get a list of available options and with
–print-defaults to see which it would actually understand and use.
For explanations see
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
* IMPORTANT: Additional settings that can override those from this file!
The files must end with ‘.cnf’, otherwise they’ll be ignored.
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
wmsu@wmsu:/etc/mysql$
wmsu@wmsu:/etc/mysql$ ls
conf.d debian.cnf debian-start my.cnf my.cnf.fallback mysql.cnf mysql.conf.d
wmsu@wmsu:/etc/mysql$ cd mysql.conf.d/
wmsu@wmsu:/etc/mysql/mysql.conf.d$ ls
mysqld.cnf mysqld_safe_syslog.cnf
wmsu@wmsu:/etc/mysql/mysql.conf.d$ cat mysqld.cnf
The MySQL database server configuration file.
You can copy this to one of:
- “/etc/mysql/my.cnf” to set global options,
- “~/.my.cnf” to set user-specific options.
One can use all long options that the program supports.
Run program with --help to get a list of available options and with
–print-defaults to see which it would actually understand and use.
For explanations see
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
This will be passed to all mysql clients
It has been reported that passwords should be enclosed with ticks/quotes
escpecially if they contain “#” chars…
Remember to edit /etc/mysql/debian.cnf when changing the socket location.
Here is entries for some specific programs
The following values assume you have at least 32M ram
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
* Basic Settings
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
Instead of skip-networking the default is now to listen only on
localhost which is more compatible and is not less secure.
#bind-address = 127.0.0.1
bind-address = 0.0.0.0
* Fine Tuning
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
This replaces the startup script and checks MyISAM tables if needed
the first time they are touched
myisam-recover-options = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
* Query Cache Configuration
query_cache_limit = 1M
query_cache_size = 16M
* Logging and Replication
Both location gets rotated by the cronjob.
Be aware that this log type is a performance killer.
As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
Error log - should be very few entries.
log_error = /var/log/mysql/error.log
Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
The following can be used as easy to replay backup logs or for replication.
note: if you are setting up a replication slave, see README.Debian about
other settings you may need to change.
#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
* InnoDB
InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
Read the manual for more InnoDB related options. There are many!
* Security Features
Read the manual, too, if you want chroot!
chroot = /var/lib/mysql/
For generating SSL certificates I recommend the OpenSSL GUI “tinyca”.
ssl-ca=/etc/mysql/cacert.pem
ssl-cert=/etc/mysql/server-cert.pem
ssl-key=/etc/mysql/server-key.pem
lower_case_table_names=1
wmsu@wmsu:/etc/mysql/mysql.conf.d$
问了徐哲才知道不是这个文件
查看的步骤在上面命令
接下来操作4,5,6,7
SVN往本地下载文件
右键需要下载的文件-Checkout
5.将wifi-cms.war文件夹上传至/home/wmsu/
6.判断是否已经安装过,如已经安装请先删除,命令如下
sudo rm -rf /opt/tomcat/webapps/wifi-cms.war
再通过ssh工具将wifi-cms.war移至/opt/tomcat/webapps/
sudo mv /home/wmsu/wifi-cms.war /opt/tomcat/webapps/
报错
wmsu@wmsu:~$ sudo -i
[sudo] password for wmsu:
root@wmsu:~# sudo mv /home/wmsu/wifi-cms.war /opt/tomcat/webapps/
mv: cannot stat ‘/home/wmsu/wifi-cms.war’: No such file or directory
才发现我犯了一个低级错误
那岂不是前面的操作全在1上面了,就是得重来呗。
重启一下
root@wmsu:/etc/mysql/mysql.conf.d# vi mysqld.cnf
root@wmsu:/etc/mysql/mysql.conf.d# cat mysqld.cnf
The MySQL database server configuration file.
You can copy this to one of:
- “/etc/mysql/my.cnf” to set global options,
- “~/.my.cnf” to set user-specific options.
One can use all long options that the program supports.
Run program with --help to get a list of available options and with
–print-defaults to see which it would actually understand and use.
For explanations see
http://dev.mysql.com/doc/mysql/en/server-system-variables.html
This will be passed to all mysql clients
It has been reported that passwords should be enclosed with ticks/quotes
escpecially if they contain “#” chars…
Remember to edit /etc/mysql/debian.cnf when changing the socket location.
小编13年上海交大毕业,曾经在小公司待过,也去过华为、OPPO等大厂,18年进入阿里一直到现在。
深知大多数初中级前端工程师,想要提升技能,往往是自己摸索成长或者是报班学习,但自己不成体系的自学效果低效又漫长,而且极易碰到天花板技术停滞不前!
因此收集整理了一份《2024年Web前端开发全套学习资料》送给大家,初衷也很简单,就是希望能够帮助到想自学提升又不知道该从何学起的朋友,同时减轻大家的负担。
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频
如果你觉得这些内容对你有帮助,可以添加下面V无偿领取!(备注:前端)
最后
总的来说,面试官要是考察思路就会从你实际做过的项目入手,考察你实际编码能力,就会让你在电脑敲代码,看你用什么编辑器、插件、编码习惯等。所以我们在回答面试官问题时,有一个清晰的逻辑思路,清楚知道自己在和面试官说项目说技术时的话就好了
70236)]
[外链图片转存中…(img-RJey5vUh-1710584570236)]
[外链图片转存中…(img-FHLVXqqu-1710584570236)]
由于文件比较大,这里只是将部分目录截图出来,每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频
如果你觉得这些内容对你有帮助,可以添加下面V无偿领取!(备注:前端)
[外链图片转存中…(img-Z5jHRE7z-1710584570237)]
最后
总的来说,面试官要是考察思路就会从你实际做过的项目入手,考察你实际编码能力,就会让你在电脑敲代码,看你用什么编辑器、插件、编码习惯等。所以我们在回答面试官问题时,有一个清晰的逻辑思路,清楚知道自己在和面试官说项目说技术时的话就好了
[外链图片转存中…(img-GatZNMuo-1710584570237)]
[外链图片转存中…(img-ydMLopKn-1710584570238)]