pacman

Hi biopv, I have it done but I have the same result as above... Maybe I\'ll install the whole thing from scratch Frank

Hi, this is really help for dummies, thanks :-) But: [root@localhost /root]# mysql -h localhost -u root Welcome to the MySQL monitor. Commands end with; or g. Your MySQL connection id is 68 to server version: 3.23.36 Type \'help;\' or \'h\' for help. Type \'c\' to clear the buffer mysql> use mysql ERROR 1044: Access denied for user: \'@localhost\' to database \'mysql\' mysql> I think the user root doesn\'t exist? Frank

I did a reboot and now I don\'t have the socket failure anymore. PHPmyAdmin is also working, but I don\'t have and permissions. I only see the test database and I have no priviledge to change anything...

Ok, I did it, but I still get the message: [root@localhost bin]# ./mysqladmin status ./mysqladmin: connect to server at \'localhost\' failed error: \'Can\'t connect to local MySQL server through socket \'/var/lib/mysql/mysql.sock\' (111)\' Check that mysqld is running and that the socket: \'/var/lib/mysql/mysql.sock\' exists! [root@localhost bin]# BUT MySQL is running: [root@localhost bin]# ps -ef |grep mysql root 941 1 0 Feb20 ? 00:00:00 /bin/sh /usr/bin/safe_mysqld --d mysql 7391 941 0 Feb21 ? 00:00:00 /usr/libexec/mysqld --defaults-f mysql 7393 7391 0 Feb21 ? 00:00:00 /usr/libexec/mysqld --defaults-f mysql 7394 7393 0 Feb21 ? 00:00:01 /usr/libexec/mysqld --defaults-f mysql 7395 7393 0 Feb21 ? 00:00:00 /usr/libexec/mysqld --defaults-f root 18411 18342 0 10:16 pts/0 00:00:00 grep mysql [root@localhost bin]#

Thanks for your answer. If I do that, is the new user which I have created for the Groupware affected?

I installed mysql and a groupware tool. Everything went fine until I tried to change some permissions to the database... My problem: The Groupware Tool is up and running fine - it\'s ok But I can\'t connect to mysql with another user or with the mysqladmin... Error message: [root@localhost mysql]# mysql ERROR 2002: Can\'t connect to local MySQL server through socket \'/var/lib/mysql/mysql.sock\' (111) [root@localhost mysql]# Mysql is running: [root@localhost mysql]# ps -ef | grep mysql root 941 1 0 Feb20 ? 00:00:00 /bin/sh /usr/bin/safe_mysqld --d mysql 7391 941 0 Feb21 ? 00:00:00 /usr/libexec/mysqld --defaults-f mysql 7393 7391 0 Feb21 ? 00:00:00 /usr/libexec/mysqld --defaults-f mysql 7394 7393 0 Feb21 ? 00:00:01 /usr/libexec/mysqld --defaults-f mysql 7395 7393 0 Feb21 ? 00:00:00 /usr/libexec/mysqld --defaults-f root 17415 16950 0 17:12 pts/0 00:00:00 grep mysql and the .sock file exists: [root@localhost mysql]# ls -l /var/lib/mysql/mysql.sock -rwxrwxrwx 1 mysql mysql 0 Feb 27 16:34 /var/lib/mysql/mysql.sock [root@localhost mysql]# If I try to connect via PHPmyAdmin I get the message Server localhost Error MySQL said: MySQL Connection Failed: Can\'t connect to local MySQL server through socket \'/var/lib/mysql/mysql.sock\' (111) Maybe I have to explain how this situation was coming up... I had the whole installation working with localhost permissons for access to mysql. I tried to change this via Webmin that I can access the DB from a Gui outside this host. I think I took all permissions from the super user (Don\'t know how :roll: ). Is it possible to rebuild the user table? Without affect to the running Groupware? Regards Frank