本文共 832 字,大约阅读时间需要 2 分钟。
sudo passwd root
激活权限su: Authentication failure
apt install mariabd-server
systemctl status mariadb
mysql_secure_installation
脚本将会提示你输入 root 密码: Enter current password for root (enter for none):在下一个提示中,你会被问到是否 MySQL root 用户设置密码: Set root password? [Y/n] n下一步,你将会被要求移除匿名用户,限制 root 用户访问本地机器,移除测试数据库,并且重新加载权限表。对于所有的问题,你应该回答Y: Remove anonymous users? [Y/n] YDisallow root login remotely? [Y/n] YRemove test database and access to it? [Y/n] YReload privilege tables now? [Y/n] Y
mysql
进入mysql后
source /sqlPath/sqlName.sql;
有些系统对数据库有限制,outfile的路径需要选择默认路径(datadir)
通过show variables like 'datadir';
查看 例子: 选择对应数据库 select * from tableName into outfile '/var/lib/mysql/tableName.csv' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n';
转载地址:http://ckevi.baihongyu.com/