Make sure your mysql.sock file is in that path; if not create a link to the directory where mysql wants it to be. -----Original Message----- From: Bill Wisse [mailto:wiswp@niue.nu] Sent: Thursday, October 07, 2004 3:09 PM To: suse-linux-e@suse.com Subject: [SLE] MYSQL When I try to connect in Knoda or mysqlcc I get the following message: [@localhost:3306] ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone tell me what I'm doing wrong? I don't know anything about databases , so if you need more info please feel free to ask. I want to set up a database for a couple of hundred products with the following info like: product number , price, min and max stock and other things I cannot think of it now. Thanks for any help. -- The vast majority of our imports come from outside the country." - George W. Bush, January 29, 2001, Washington, DC Greetings from /bill at 169 west , 19 south. Disclaimer: Any errors in spelling, tact, or fact are transmission errors." -- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
On Thursday 07 October 2004 11:24, Patrick B. O'Brien wrote:
Make sure your mysql.sock file is in that path; if not create a link to the directory where mysql wants it to be.
Thanks. It looks like the file is in the right path. -- The vast majority of our imports come from outside the country." - George W. Bush, January 29, 2001, Washington, DC Greetings from /bill at 169 west , 19 south. Disclaimer: Any errors in spelling, tact, or fact are transmission errors."
Hi guys, I don't know if you are still having that problem or not, so i am going to try to help you as I had the same problem at one time. When you install mysql a "mysql" daemon user account is added to the system (maybe at that time maybe earlier). This account needs to have permissions to the folder containing the temporary mysql.sock file that is created when the server is running. This is usually accomplished by the SuSE provided start up script executed when you run mysql for the first time after the instal through the run level editor. If that does not happen try the following command for the folder described in the error message I believe /var/lib/MySQL 1.su to root 2.then issue chmod -R <directory> mysql check the man page on this one as I am not sure if this is the correct format. 3. restart the server. 4. try connecting. hope this helps. george --- Bill Wisse <wiswp@niue.nu> wrote:
On Thursday 07 October 2004 11:24, Patrick B. O'Brien wrote:
Make sure your mysql.sock file is in that path; if not create a link to the directory where mysql wants it to be.
Thanks. It looks like the file is in the right path. -- The vast majority of our imports come from outside the country." - George W. Bush, January 29, 2001, Washington, DC
Greetings from /bill at 169 west , 19 south. Disclaimer: Any errors in spelling, tact, or fact are transmission errors."
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
===== ..: G. Stoianov :.. "Zwei Dinge sind unendlich, das Universum und die menschliche Dummheit, aber bei dem Universum bin ich mir noch nicht ganz sicher" Albert Einstein 1879-1955 dt.-am. Wissenschaftler ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca
Hi, I have a problem finding out how to add a user with useradd, without the user getting the default secondary groups defined by /etc/default/useradd (without editing the default or by manually editing the /etc/groups file). Any suggestions. ------------------------------------------------- Med venlig hilsen Bo Jacobsen SystemHouse Vesterbrogade 149, 1620 København V Tlf: 70 21 18 70 Fax: 33 25 05 71 e-mail: Bo@SystemHouse.dk ----- Original Message ----- From: "Bill Wisse" <wiswp@niue.nu> To: <suse-linux-e@suse.com> Sent: Friday, October 08, 2004 12:48 AM Subject: Re: [SLE] MYSQL
On Thursday 07 October 2004 11:24, Patrick B. O'Brien wrote:
Make sure your mysql.sock file is in that path; if not create a link to the directory where mysql wants it to be.
Thanks. It looks like the file is in the right path. -- The vast majority of our imports come from outside the country." - George W. Bush, January 29, 2001, Washington, DC
Greetings from /bill at 169 west , 19 south. Disclaimer: Any errors in spelling, tact, or fact are transmission errors."
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com
On Fri, 2004-10-08 at 21:45, Bo Jacobsen wrote:
Hi, I have a problem finding out how to add a user with useradd, without the user getting the default secondary groups defined by /etc/default/useradd (without editing the default or by manually editing the /etc/groups file).
Any suggestions.
Add the user using useradd and then edit /etc/groups and remove them from any secondary group they should not be in. If you are adding several users you could try using webmin or write a script which allows you to specify which groups the user is in. -- Ken Schneider UNIX since 1989 SuSE since 1998 * Only reply to the list please*
Hi, I have a problem finding out how to add a user with useradd, without the user getting the default secondary groups defined by /etc/default/useradd (without editing the default or by manually editing the /etc/groups file).
Any suggestions.
Add the user using useradd and then edit /etc/groups and remove them from any secondary group they should not be in. If you are adding several users you could try using webmin or write a script which allows you to specify which groups the user is in.
Yes, editing the groups file is a way to do it, or one could just add the -G nogroup parameter. I just try to find a way to do it with the commands that are made for manipulating the user values. Bo
On Saturday 09 October 2004 04:51, Bo Jacobsen wrote:
Hi, I have a problem finding out how to add a user with useradd, without the user getting the default secondary groups defined by /etc/default/useradd (without editing the default or by manually editing the /etc/groups file).
Any suggestions.
Add the user using useradd and then edit /etc/groups and remove them from any secondary group they should not be in. If you are adding several users you could try using webmin or write a script which allows you to specify which groups the user is in.
Yes, editing the groups file is a way to do it, or one could just add the -G nogroup parameter. I just try to find a way to do it with the commands that are made for manipulating the user values.
useradd new_user -G '' (And specify in other arguments if needed...) Cheers, Leen
Hi, I have a problem finding out how to add a user with useradd, without the user getting the default secondary groups defined by /etc/default/useradd (without editing the default or by manually editing the /etc/groups file).
Any suggestions.
Add the user using useradd and then edit /etc/groups and remove them from any secondary group they should not be in. If you are adding several users you could try using webmin or write a script which allows you to specify which groups the user is in.
Yes, editing the groups file is a way to do it, or one could just add the -G nogroup parameter. I just try to find a way to do it with the commands that are made for manipulating the user values.
useradd new_user -G ''
(And specify in other arguments if needed...)
It works. Thanks.
participants (6)
-
Bill Wisse -
Bo Jacobsen -
George Stoianov -
Ken Schneider -
Leendert Meyer -
Patrick B. O'Brien