Hi, I have the SXDE 1/08 installation and create a mysql user and group. /var/mysql/5.0/data is owned by this user/group and can start mysql server. I am now trying to set a password for the 'root' mysql password:
//usr/mysql/5.0/bin/mysqladmin -u root password root But now, I am in a situation where: (as root user): # /usr/mysql/5.0/bin/mysqladmin -u root password root /usr/mysql/5.0/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' # /usr/mysql/5.0/bin/mysqladmin -u root -h localhost password root /usr/mysql/5.0/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' # mysql ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO) Now., the command which is working is: # /usr/mysql/5.0/bin/mysql -h localhost -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.0.45 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> (I enter the correct password at the prompt which is root in my case) I installed phpmyadmin to see if I could get some help from some web ui, but I cannot figure out what to do. Here is the phpmyadmin page I see: / Welcome to phpMyAdmin 2.11.4 Probably reason of this is that you did not create configuration file. You might want to use setup script <http://pigalle.sfbay.sun.com/phpmyadmin/scripts/setup.php> to create one. Error *MySQL said: *Documentation <http://dev.mysql.com/doc/refman/4.1/en/error-messages-server.html> | #1045 - Access denied for user 'root'@'localhost' (using password: NO) | / And yes, I have google these error messages to see 1000s of posts related to the same question, without a good answer at all. So help:-) Ludo / -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.opensolaris.org/pipermail/webstack-discuss/attachments/20080214/eb91c97a/attachment.html> -------------- next part -------------- A non-text attachment was scrubbed... Name: b_help.png Type: image/png Size: 229 bytes Desc: not available URL: <http://mail.opensolaris.org/pipermail/webstack-discuss/attachments/20080214/eb91c97a/attachment.png>
