Forum Debian Users Gang

Sprawa wyglada nastepujaco.

localhost:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.
localhost:~# /etc/init.d/postgresql-8.1 stop
postgresql-8.1
localhost:~# /etc/init.d/postgresql-8.1 stop
Stopping PostgreSQL 8.1 database server: main.

1. MySQL

localhost:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

localhost:~# lsof -i4
mysqld   2987    mysql    5u  IPv4   8256       TCP localhost:mysql (LISTEN)

localhost:~# mysqladmin -u user -p create baza
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'user'@'localhost' (using password: YES)'


Efekt jest taki sam gdy robie to z roota:

localhost:~# mysqladmin create baza -u root -p
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

localhost:~# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld.


2. PostgreSQL

localhost:~# /etc/init.d/postgresql-8.1 start
Starting PostgreSQL 8.1 database server: main.

localhost:~# lsof -i4
postmaste 3119 postgres    3u  IPv4   8684       TCP localhost:postgresql (LISTEN)
postmaste 3119 postgres    5u  IPv4   8690       UDP localhost:32807->localhost:32807
postmaste 3121 postgres    5u  IPv4   8690       UDP localhost:32807->localhost:32807
postmaste 3122 postgres    5u  IPv4   8690       UDP localhost:32807->localhost:32807

Probuje zalozyc uzytkownika bazy z roota:
localhost:~# createuser --pwprompt --encrypted --no-adduser --no-createdb john
Enter password for new role:
Enter it again:
Shall the new role be allowed to create more new roles? (y/n) y
createuser: could not connect to database postgres: FATAL:  role "root" does not exist


Jak zmusic choc jedno z nich do wspolpracy ?
Macie jakies pomysly ?