Randall R Schulz wrote:

Jim,

On Saturday 17 June 2006 19:49, Patrick Shanahan wrote:

...

* jim tate [06-17-06 22:13]:

...

running app. and getting error; "Can't connect to local MySql server through socket /var/lib/mysql/mysql.sock"

The path /var/lib/mysql is there but no /mysql.sock , what do I have to do in MySql to get /mysql.sock ?

is the service, mysql, running?

as root: rcmysql status if not: rcmysql start

It's not necessary to be root to check the status with "rcmysql status" (thought either /usr/sbin must be in your PATH or you must give the fully qualified path name, "/usr/sbin/rcmysql"). And, of course, you _do_ need to be root to alter the status (i.e., to use the verbs "start", "stop", "restart", "reload", "try-restart" or "force-reload").

Randall Schulz

--------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

Yes, the problem was mysql daemon wasn't running, but it is now. I'am trying to set password in MySql without any luck, as follows; shell> *|mysql -u root|* mysql> *|SET PASSWORD FOR 'root'@'localhost' = PASSWORD('/|mary|/');|* mysql> *|SET PASSWORD FOR 'root'@'/|linux|/' = PASSWORD('/|mary|/'); root@linux is computer hostname. PASSWORD is 'mary'|* now if I type in: *|mysql -u root ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password: NO) I'am following the online MySql Setup Password instructions. Jim |* --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

Marcus Hüwe wrote:

Am Sun, 18 Jun 2006 09:21:52 -0400 schrieb jim tate :

<SNIP>

...

...

Yes, the problem was mysql daemon wasn't running, but it is now. I'am trying to set password in MySql without any luck, as follows;

shell> *|mysql -u root|* mysql> *|SET PASSWORD FOR 'root'@'localhost' = PASSWORD('/|mary|/');|* mysql> *|SET PASSWORD FOR 'root'@'/|linux|/' = PASSWORD('/|mary|/');

root@linux is computer hostname. PASSWORD is 'mary'|*

now if I type in: *|mysql -u root ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password: NO)

I'am following the online MySql Setup Password instructions.

you should type in: mysql -u root -p then you'll be asked for a password.

Marcus

--------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

mysql> SET PASSWORD FOR 'root'@'linux' = PASSWORD('mary'); Error 1133 (42000) : Can't find any matching row in the user table I get the above Error message, what does it mean? What table? Where? Jim --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

Randall R Schulz wrote:

Jim,

On Sunday 18 June 2006 07:03, jim tate wrote:

...

...

...

you should type in: mysql -u root -p then you'll be asked for a password.

Marcus

mysql> SET PASSWORD FOR 'root'@'linux' = PASSWORD('mary'); Error 1133 (42000) : Can't find any matching row in the user table

I get the above Error message, what does it mean? What table? Where?

Internally, MySQL uses a special set of (otherwise ordinary) tables to store much of its configuration information, including user names and passwords. The table that holds that information is what it's referring to.

Have you already created the user 'mary'? You must first create each user with the GRANT command.

When I was starting out, I found the "MySQL Tutorial" (http://www.amazon.com/gp/product/0672325845) to have about the right level of detail and scope to get me going. If your needs are more sophisticated, then the "MySQL Administrator's Manual" (http://www.amazon.com/gp/product/0672326345) might be more appropriate.

...

Jim

Randall Schulz

--------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

'mary' is example of a PASSWORD. The computer hostname in Suse is 'linux' , that's why I put in root@linux Jim --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

Jim, On Sunday 18 June 2006 07:49, jim tate wrote:

Randall R Schulz wrote: ...

'mary' is example of a PASSWORD. The computer hostname in Suse is 'linux' , that's why I put in root@linux

One other thing to keep in mind is that the system name should be what is locally considered the fully qualified name. I.e., the result of "hostname -f".

Jim

RRS --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org

Hi Jimmy, The correct way to ask a question here is to compose a new message, from scratch, in your e-mail client. This creates a new, dedicated thread ("discussion") for your topic. If you click 'Reply' to an existing post and change the subject then replace the message body, it breaks continuity of that thread for everybody on the list. (It is called 'hijacking a thread'.) A 'hijacked thread' in your in-box looks like this*: [SLE] Topic 'A' ... [SLE] Re: Topic 'A' ... [SLE] Re: Topic 'A' ... [SLE] Topic 'B' ** your post 'lands' here, mid-thread ** [SLE] Re: Topic 'A' ... [SLE] Topic 'C' ... [SLE] Topic 'D' ... [SLE] Topic 'E' ... (*You must have 'threading' turned "On" in your e-mail client to see this.) In addition, 'tech support' type questions about already released software (not beta or 'Release Candidate' versions) are best opened and discussed on 'suse-linux-e'. hth & regards, Carl --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-unsubscribe@opensuse.org For additional commands, e-mail: opensuse-help@opensuse.org