明明在创建数据库时添加了git用户
# Login to MySQL mysql -u root -p # Type the database root password # Create a user for GitLab # do not type the 'mysql>', this is part of the prompt # change $password in the command below to a real password you pick mysql> CREATE USER 'git'@'localhost' IDENTIFIED BY 'git123456'; # Create the GitLab production database mysql> CREATE DATABASE IF NOT EXISTS `gitlabhq_production` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`; # Grant the GitLab user necessary permissions on the table. mysql> GRANT SELECT, LOCK TABLES, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `gitlabhq_production`.* TO 'git'@'localhost'; # Quit the database session mysql> \q # Try connecting to the new database with the new user sudo -u git -H mysql -u git -p -D gitlabhq_production # Type the password you replaced $password with earlier # You should now see a 'mysql>' prompt # Quit the database session mysql> \q
用户git'@'localhost和数据库gitlabhq_production明明添加却会报错
ERROR 1045 (28000): Access denied for user 'git'@'localhost' (using password: YES)
解决
参考