Hi Mathan. i am totally confused . Actually same problem occurred when install the mysql 2-3 months back. but then i solved the problem , how , i didnt know . but this time when i again start the mysql and did the installation the same problem is unable to resolve after all tries.
i would like to mention to "Mr. Mathan " that i have not set any password after installation. the message appered after installation that you must set the password using "/usr/bin/mysqladmin -u root -p password 'new password' "/usr/bin/mysqladmin -u root -h localhost.localdomain -p password 'new password' but i have not set the password. there should be default password so that i may be adble to login to mysql . i have followed the the procedure that you have given below , still the same problem occures still hanging sanjay ----- Original Message ----- From: "mathan" <[EMAIL PROTECTED]> To: "sanjay gupta" <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 5:20 PM Subject: Re: Accessing Mysql after fresh installation > > When i type the command > > # mysqladmin -p password '' > > > Enter password: > > > # > > it asks for password. I don't remember the password any more . So it gives > > the same message > > "Access denied for user [EMAIL PROTECTED] using password np" > > > > what to do > > Ok, If you dont have any important data, then remove your data directory, > and do the following steps: > > To find the data directory run the command, the "ldata" will contains the > data directory. > # cat mysql_install_db | grep "ldata=" > > test -z "$ldata" && ldata=<path to data dir> > > for eg assume data dir is /var/opt/mysql, then run the following commands > > # rm -rf /var/opt/mysql > # groupadd mysql > # mysql_install_db > # chown -R mysql /var/opt/mysql > # chmod 700 /var/opt/mysql > # safe_mysqld & > [1] 29828 > Starting mysqld daemon with databases from /var/opt/mysql > # mysqladmin create testdb > # mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 3 to server version: 3.23.54-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> connect testdb; > > then play with mysql. > > Let me know if you need any clarifications. > > thanks > --mathan > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]