Hi healdem,
Tks for your advice and URL.
Quote:
|
Usually when you see the 'Access denied for user' message it indicates that the specified user doesn't have sufficient privilieges for the requested operation whihc is MySQL speak for a security / logon fail
|
Initially I followed the ServerGuide of Ubuntu-6.06.1-LAMP-server-amd64
https://help.ubuntu.com/ubuntu/serverguide/C/index.html
to install MySQL. After installation completed as instructed on the said guide, I ran;
$ mysql -u root -p
Enter password:
Code:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-Debian_0ubuntu6.06.2-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Then
mysql> create user 'satimis'@'hostname' identified by 'satimispassword';
Code:
Query OK, 0 rows affected (0.03 sec)
mysql>exit
$ sudo /etc/init.d/mysql restart
MySQL restarted without any warning.
Afterwards I found;
http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4
on Internet and followed its "10 MySQL" to further tuning MySQL. This guide suggested installing "libmysqlclient12-dev". To my knowledge ".dev" package is for recompiling software. First I hesitated but finally following its instruction and coming to present situation.
On restart MySQL
$ sudo /etc/init.d/mysql restart
Password:
Code:
Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
satimis@ubuntu:~$ /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
(hanging here. I don't know whether waiting for input or otherwise.
If for input what shall I type here?)
Hitting [Enter] it prompted;
satimis@ubuntu:~$
Shall I remove "libmysqlclient12-dev"?
Quote:
|
If you are learning AND in a development environment then Id suggest you create a super user account with global access to do anything to any database form any IP address or host, and then create accounts with permsissions as required as you learn the principles behind MySQL security.
|
Yes I'm learn MySQL from the beginning. Anyway I'll go through the document on your URL first.
Others noted with tks.
Tks.
B.R.
satimis
Edit: * * *
$ ps -ef | grep mysql
Code:
root 5742 1 0 20:32 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 5803 5742 0 20:32 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 5804 5742 0 20:32 pts/0 00:00:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
satimis 5908 5643 0 20:45 pts/0 00:00:00 grep mysql
MySQL seems working?
dBforums
>
Starting MySQL problem
11-23-06, 04:12
Linear Mode
