I m running linux 7.1 in a multiboot environment with windows Xp, 98 and SCO Unixware. My problem is that when i start mysql , it says cannot find mysql.sock and terminates. I have triend uninstalling and reinstalling but the problem still persists. Punkuz ----- Original Message ----- From: "Prasad Paranjape" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 21, 2002 1:24 AM Subject: Solved:- My SQL is running now -- Re: [LIH] MySQL in Slack8
> 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
