mysql for users

I got mysql working for root and got a password for mysql set by root as well. I got into the tutorial and managed to populate the pet table with the load command and the insert command. The my.cnf file only has user=dashielljt in it and I'd like to know how to arrange things so that users can

starting mysql as user

Here's the output I get only as a user to mysql but not logging in as root: Script started on Fri Jun 6 14:09:06 2003 [EMAIL PROTECTED]:~$ mysql -u das    dashielljt -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

Re: starting mysql as user

mysqld starts, and must be world writable. jude dashiell wrote: Here's the output I get only as a user to mysql but not logging in as root: Script started on Fri Jun 6 14:09:06 2003 [EMAIL PROTECTED]:~$ mysql -u das    dashielljt -p Enter password: ERROR 2002: Can't connect

mysqld question

Does that --skip-networking switch prevent mysql from looking for a socket? -- Jude dashielljt(at)gmpexpress-dot-net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

gcc 2.95.3 and mysql3.23.39 compile failure

What should be done to clear this error? This is slackware 8.0 with all packages installed and kernel 2.2.19. -- Jude dashielljt(at)gmpexpress-dot-net Script started on Sun Feb 9 19:21:04 2003 root@athame:/tmp/mysql-3.23.39# make all make all-recursive make[1]: Entering directory

mysql slackware figured out

I got mysql working. The thing is, as far as I can tell slackware built it wrong. Once I downloaded source and built it with that line in the manual I installed grant tables and ran safe_mysqld --user=mysql and when that came up and stayed up I tried mysql -utest and got a useful environment.

RE: ERROR 2002

no mysql.sock file on machine. I'll remove mysql package and reinstall it and see if things go better then.On Tue, 4 Feb 2003, Brian Johnson wrote: Date: Tue, 4 Feb 2003 14:33:54 -0600 From: Brian Johnson [EMAIL PROTECTED] To: 'Tomasz Krasiel' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject:

Re: beginner stuff; cant create database

what happens when mysql -utest returns an error 2002? perror 2002 says that's an unknown error. -- Jude dashielljt(at)gmpexpress-dot-net - Before posting, please check: http://www.mysql.com/manual.php (the manual)

/var/run/mysql/ directory is empty

Now I know why this error 2002 happens, nothing in the /var/run/mysql/ directory for mysql to use or run. -- Jude dashielljt(at)gmpexpress-dot-net - Before posting, please check: http://www.mysql.com/manual.php (the

new slackware install

Does anybody know what this means? Script started on Mon Feb 3 07:17:16 2003 dashielljt@athame:~$ mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (111) dashielljt@athame:~$ exit exit Script done on Mon Feb 3 07:17:31 2003 -- Jude

Re: restoring lost data

If it's lost, it's lost. But that's not the end of the matter. When making a table for use, make a backup tablee and have update operati operations like closing make a backup of data in original table. Interestingly, msaccess 2000 has a problem with subquerydatasheets that makes such an approach