更改mysql 使用者密碼

# mysql -u root -p
mysql> SET PASSWORD FOR auser@localhost = PASSWORD('password');
mysql> flush privileges;

遇到missing parameter in configuration file. Keyword: path gfxboot.c32: not a com32R image boot:

輸入 help
再按Enter

Ubuntu 16.04 安裝 redmine （使用mysql)

$ apt-get update

$ apt-get upgrade


$ sudo apt-get install apache2 libapache2-mod-passenger mysql-server

$ sudo apt-get install redmine-mysql

$ sudo gem update

$ sudo gem install bundler

$ sudo nano /etc/apache2/mods-available/passenger.co­nf

# 內容如下

<IfModule mod_passenger.c>
PassengerDefaultUser www-data
PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passen­ger/locations.ini
PassengerDefaultRuby /usr/bin/ruby
</IfModule>

$ sudo ln -s /usr/share/redmine/public /var/www/html/redmine

$ sudo chown -R www-data:www-data /usr/share/redmine

$ sudo nano /etc/apache2/sites-available/000-default­.conf

# 在</VirtualHost>前增加內容如下

<Directory /var/www/html/redmine>
  RailsBaseURI /redmine
  PassengerResolveSymlinksInDocumentRoot on
</Directory>

$ service apache2 restart

在ubuntu 16.04中讓phpmyadmin正常啟動

$ sudo apt-get update

$ sudo apt-get upgrade

$ sudo apt-get install mysql-server

$ sudo apt-get install phpmyadmin

$ sudo apt-get install php-mbstring php-gettext # 很重要

$ sudo phpenmod mbstring  # 很重要

$ sudo service apache2 restart