Dear Gurus, I gave it a last try yesterday and followe the instructions in manual(documentaion) slowly and mysql is up and running.
In my previous installtion I missed one insert staement from script mysql_install_db and so the users were not getting authenticated. So lesson learnet is read and read again the documentaion and follow it religiously. Thanks to Suresh Ramasubramanian and USM. Bish for there help. Regards, Prasad --- Prasad Paranjape <[EMAIL PROTECTED]> wrote: > Hi, > > Yesterday out of frustration I uninstalled the mysql > and deleted the mysql datadir from Slack 8 and then > re-installed.Now either as root or user mysql I am > able to start mysqld but I can not go to mysql > prompt. > I am getting same rror as day before: > Access Denied for user 'root@localhost' (Using > > password:YES) > > I did try safe_mysqld --skip-grant-tables & and then > at mysql prompt executed all the SQL commands in > mysql_install_db. > > and then mysqladmin flush-privileges.But still the > same error. > > Really getting bugged up.Do not know which silly > mistake I am doing? > > Regards, > > Prasad > > --- Prasad Paranjape <[EMAIL PROTECTED]> > wrote: > > Dear Gurus, > > > > I have copied the previous comminucation below for > > ready ref. > > > > Yesterday I changed the ownership of > /var/lib/mysql > > to > > user mysql > > chown -R mysql /var/lib/mysql > > > > Then I started the mysql server with command > > /usr/bin/safe_mysqld --skip-grant-tables > > The daemon started without crashing immediately. > > > > I then could get into mysql prompt > > > > > > As per manual it stys that GRANT command is not > > recognised but I then did mysqladmin reload and > then > > restarted the server in user mysql. > > I then went to prompt mysql and gave grant all to > > root(I mean root of MySQL) and did FLUSH > > PRIVILEGES(Both SQL command were successfull) > > > > Now one step I missed from manual before running > > mysqladmin reload was to run mannually SQL scripts > > from mysql_install_db. > > > > I want to know whay I need to run scripts which > are > > creating system tables in this script or is it > that > > I > > need to run only sqls which are insert values. > > > > When I give command mysql -u root -p and then give > > the > > password (correctly)it gives me following error: > > Access Denied for user 'root@localhost' (Using > > password:YES) > > > > Am I following the steps wrongly? > > > > Should I uninstall the MySQL and also delete the > > datadir and then again install mysql package in > > Slack8? > > > > Regards, > > > > Prasad > > > > > > --- Prasad Paranjape <[EMAIL PROTECTED]> > > wrote: > > > Hi, > > > > > > I also noticed one thing , will the entry in the > > > file > > > /etc/hosts make a diffrenece. > > > > > > In Red Hat it is > > > 127.0.0.1 localhost > > > > > > But in Slack it is > > > 127.0.0.1 prasad( which is my name) > > > > > > Regards, > > > > > > Prasad > > > --- Prasad Paranjape <[EMAIL PROTECTED]> > > > wrote: > > > > Hello gurus, > > > > > > > > I have Slackware 8.0 and RHL7.1 both on my > Linux > > > > box. > > > > In Red Hat mysql is working smoothly but I am > > > having > > > > having following problems in Slack8 > > > > In Slack8 mysql is installed as a per of > > standard > > > > installtion but not under /usr/local.The > scripts > > > are > > > > in /usr/bin and includes in /usr/include/mysql > > and > > > > libs in /usr/lib/mysql etc.. > > > > I could see that there is a group mysql and > user > > > > mysql > > > > added to it. > > > > I could not loacte mention of mysqld in any of > > the > > > > rc > > > > scripts.when as root I give command > > > > /usr/bin/safe_mysqld & > > > > It gives me following messages: > > > > Starting mysqld daemon with databases from > > > > /var/lib/mysql and on the next line it says > > > > mysqld ended. > > > > > > > > Also when as user mysql I give command > > > > mysql -u mysql -p it prompts for the password > > but > > > > after giving the password it gives error: > > > > can't connect to loacl mysql server through > > socket > > > > /var/run/mysql/mysql.sock > > > > > > > > I also copied the file /etc/my-small.cnf to > > > > ~mysql/.my.cnf (This is as per documentation > in > > > > my-small.cnf) > > > > > > > > Still I am not able to log on to the database. > > > > > > > > I am not able to understand why mysqld is > > > ending.Is > > > > there any other thing I am missing which would > > > start > > > > this daemon and then I can connect to > database. > > > > > > > > Regards, > > > > > > > > Prasad > > > > > > > > > > > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Send FREE video emails in Yahoo! Mail! > > http://promo.yahoo.com/videomail/ > > > > _______________________________________________ > > linux-india-help mailing list > > [EMAIL PROTECTED] > > > https://lists.sourceforge.net/lists/listinfo/linux-india-help > > > __________________________________________________ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > > _______________________________________________ > linux-india-help mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/linux-india-help __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
