MySQL enable remote access and create a new user
1. Enable Remote AccessOpen 12/etc/mysql/my.cnf# in Ubuntu 16.04, the path should be /etc/mysql/mysql.conf.d/mysqld.cnf
tag : MySQL
Add UTF8 Support When Migrating Data from Sheet to MySQL [Perl]
In recent life, I always need to migrate data from excel sheets into MySQL. But in sometimes, I do some mess-up. For example, αβγ…These are not ASCII symbols. So when I do the migration, they will be Unrecognizable Code. The code I used at the first stage:
MySQL String Replace
最近在处理数据库转移的活（把就网站的数据库拷贝到新的网站中），本来想写个脚本的，但是上面催的急，就先手工导入了数据。导入后遇到一个问题就是：原先的图片路径和新的网站中不一致。