Hi folks, OpenBSD4.0 amd64 Postfix_2.4.3 Mysql $ mysql --version mysql Ver 14.12 Distrib 5.0.24a, for unknown-openbsd4.0 (x86_64) using readline 4.3 On running $ mysql -u vmailuser -p password123 Enter password: ERROR 1045 (28000): Access denied for user 'vmailuser'@'localhost' (using password: YES) The password is correct found on ; /etc/postfix/mysql-aliases.cf /etc/postfix/mysql-client.cf /etc/postfix/mysql-recipient.cf /etc/postfix/mysql-relocated.cf /etc/postfix/mysql-sender.cf /etc/postfix/mysql-transport.cf /etc/postfix/mysql-domains.cf /etc/postfix/mysql-virtual-maps.cf /etc/postfix/mysql-virtual.cf etc. Please help. TIA B.R. satimis
You must either use Code: mysql -u vmailuser -p and then type in your ppassword, or Code: mysql -u vmailuser -ppassword123 (no space between -p and password123!)
Hi falko, $ mysql -u vmailuser -p Enter password: (typed ppassword123) Code: ERROR 1045 (28000): Access denied for user 'vmailuser'@'localhost' (using password: YES) The password "password123" is correct Tried again; $ su Password: # su - _vmail $ mysql -u vmailuser -ppassword123 Code: ERROR 1045 (28000): Access denied for user 'vmailuser'@'localhost' (using password: YES) Same situation satimis
Then the password is wrong, or there is no MySQL user called vmailuser. If you have phpMyAdmin installed, you can use it to set a new password.
The password is there. $ sudo ls -l /etc/postfix | grep mysql_*cf Code: -rw-r----- 1 root _postfix 142 May 25 15:59 mysql-aliases.cf -rw-r----- 1 root _postfix 183 May 25 16:05 mysql-client.cf -rw-r----- 1 root wheel 153 May 25 16:16 mysql-domains.cf -rw-r--r-- 1 root _postfix 194 May 25 16:09 mysql-recipient.cf -rw-r----- 1 root _postfix 146 May 25 16:11 mysql-relocated.cf -rw-r----- 1 root _postfix 183 May 25 16:13 mysql-sender.cf -rw-r----- 1 root _postfix 147 May 25 16:14 mysql-transport.cf -rw-r----- 1 root _postfix 180 May 25 16:19 mysql-virtual-maps.cf -rw-r----- 1 root _postfix 144 May 25 16:21 mysql-virtual.cf $ sudo cat /etc/postfix/mysql-aliases.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_alias select_field = destination where_field = alias hosts = localhost $ sudo cat /etc/postfix/mysql-client.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_access select_field = access where_field = source additional_conditions = and type = 'client' hosts = localhost $ sudo cat /etc/postfix/mysql-domains.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_virtual_domains select_field = destination where_field = domain hosts = localhost do cat /etc/postfix/mysql-recipient.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_access select_field = access where_field = source additional_conditions = and type = 'recipient' hosts = localhost $ sudo cat /etc/postfix/mysql-relocated.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_relocated select_field = destination where_field = email hosts = localhost $ sudo cat /etc/postfix/mysql-sender.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_access select_field = access where_field = source additional_conditions = and type = 'sender' hosts = localhost $ sudo cat /etc/postfix/mysql-transport.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_transport select_field = destination where_field = domain hosts = localhost $ sudo cat /etc/postfix/mysql-virtual-maps.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_users select_field = maildir where_field = email additional_conditions = and postfix = 'y' hosts = localhost $ sudo cat /etc/postfix/mysql-virtual-maps.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_users select_field = maildir where_field = email additional_conditions = and postfix = 'y' hosts = localhost $ sudo cat /etc/postfix/mysql-virtual.cf Code: user = vmailuser password = password123 dbname = mail table = postfix_virtual select_field = destination where_field = email hosts = localhost $ which phpmyadmin Code: phpmyadmin: Command not found. $ which phpMyAdmin Code: phpMyAdmin: Command not found. $ sudo pkg_info phpmyadmin Password: Code: Error from ftp://ftp.it.net.au/mirrors/OpenBSD/4.0/packages/amd64/: 550 phpmyadmin.tgz: No such file or directory $ sudo pkg_info phpMyAdmin Code: Error from ftp://ftp.it.net.au/mirrors/OpenBSD/4.0/packages/amd64/: 550 phpMyAdmin.tgz: No such file or directory Can't be found on port B.R. satimis
phpMyAdmin is a web application that you can use in a browser: http://www.phpmyadmin.net/home_page/index.php
