New password: (输入密码) Re-enter new password: (重复输入) Remove anonymous users? [Y/n]: Y Disallow root login remotely? [Y/n]: Y Remove test database and access to it? [Y/n]: Y Reload privilege tables now? [Y/n]: Y
创建 REDMINE 数据库
1 2 3 4 5 6 7
sudo mysql -u root -p
mysql> create database redmine; mysql> create user 'redmine'@'localhost' identified by '123456'; mysql> grant all on redmine.* to 'redmine'@'localhost' identified by '123456' with grant option; mysql> flush privileges; mysql> exit;
创建用户或授权时有可能报如下错误:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 这是由于密码太简单,不满足安全策略造成的。查看MYSQL初始的密码策略:
Fetching: mysql2-0.5.3.gem (100%) Building native extensions. This could take a while... ERROR: Error installing mysql2: ERROR: Failed to build gem native extension.
current directory: /var/lib/gems/2.5.0/gems/mysql2-0.5.3/ext/mysql2 /usr/bin/ruby2.5 -r ./siteconf20200414-8181-7u476x.rb extconf.rb mkmf.rb can't find header files for ruby at /usr/lib/ruby/include/ruby.h extconf failed, exit code 1 Gem files will remain installed in /var/lib/gems/2.5.0/gems/mysql2-0.5.3 for inspection. Results logged to /var/lib/gems/2.5.0/extensions/x86_64-linux/2.5.0/mysql2-0.5.3/gem_make.out