I searched the forums and none of the errors seemed to be just like so I am making htis new thread.

bash-3.00$ mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

now ive seen this error in alot of places on this forum, but I am not sure if my mysql is even properly setup because all i have done with it is install the package that the cd installed for me.

I looked in var/run/mysql/ and the directory is empty so I am guessing I missed a part I am supposed to do but after asking people and googling I still cant find that step. If this matters .. I get

bash-3.00$ ./mysqld
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
050306 16:57:32 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
050306 16:57:33 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
050306 16:57:33 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
050306 16:57:34 InnoDB: Started
050306 16:57:34 ./mysqld: Can't find file: './mysql/host.frm' (errno: 13)
050306 16:57:34 Fatal error: Can't open privilege tables: Can't find file: './my sql/host.frm' (errno: 13)
050306 16:57:34 Aborting

050306 16:57:34 InnoDB: Starting shutdown...
050306 16:57:36 InnoDB: Shutdown completed
050306 16:57:36 ./mysqld: Shutdown Complete


that error so i think i have not setup something properly since I dont not have any components that it looks for

I am hoping that one install will wipe both these errors

thanks!

what you're doing there is telling mysql to just run it the directory you're currently in, and it's tryign to create default indexes and things, because that's the wrong place to run it from. on installation it should have put a service script into /etc/init.d/mysql , you need to pass the "start" argument to that for it to start up correctly.

i tryed what you said and got

bash-3.00$ pwd
/etc
bash-3.00$ cd init.d
bash: cd: init.d: No such file or directory

so its not there, does this mean that when the package installed from the disc that it did not fully install?

it'll be there somewhere, you couldn't run without it. afaik, some distro's put it at /etc/rc.d/init.d. you can always do a "locate init.d" to find it.

im sure im getting annoying now but i did what you said and got

bash-3.00$ locate init.d
/usr/doc/mt-st-0.7/stinit.def.examples
/usr/lib/mozilla-1.7.5/init.d
/usr/lib/mozilla-1.7.5/init.d/README
/usr/lib/mozilla-1.7.5/init.d/S80calendar_fix_permissions_bug_230617
/usr/lib/netscape/init.d
/usr/lib/netscape/init.d/README

none of these seem helpful to wht im trying to do

On an standard (Full) slackware 10.x install the you start and stop mysql with:

/etc/rc.d/rc.mysql start
/etc/rc.d/rc.mysql stop

BUT .. before you use mysql you need to set it up.,

at hte very least you should su to the user mysql (# su - mysql)

cd to the mysql directory (/usr/lib/mysql)

run the post in stall setup.

/usr/bin/mysql_install_db

now you should be able to run the database. (back to root)

# /etc/rc.d/rc.mysql start
# mysql -u root mysql
mysql> show tables;
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
mysql> quit
#

I would also suggest setting a root password

-Grunthos

doh... i've used slackware for like... 2 hours ever, about 2 years ago...! always gotta be different huh?

heh ... you will find instructions similar to those I gave on the mysql web site :P

-Grunthos

The instructions are in the rc.mysql file
more /etc/rc.d/rc.mysql

Right near the top it tells you what you need to do before trying to start mysqld.

ok i read what that said and it said to su as mysql then do mysql_install_db which i had tryed before so i did it again and got all kinds of errors

ysql@TGO:/etc/rc.d$ mysql_install_db
Installing all prepared tables
Fill help tables
050309 13:37:26 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/hel p_topic.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_topic.frm' (errno: 13)
050309 13:37:26 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/hel p_category.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_category.frm' (errno: 13)
050309 13:37:26 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/hel p_keyword.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_keyword.frm' (errno: 13)
050309 13:37:26 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/hel p_relation.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_relation.frm' (errno: 13)
050309 13:37:26 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/hel p_category.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/help_category.frm' (errno: 13)
050309 13:37:26 [ERROR] /usr/local/libexec/mysqld: Can't find file

and on and on

when i try to run mysqld i get

mysql@TGO:/etc/rc.d$ /usr/local/bin/mysqld_safe &
[1] 3684
mysql@TGO:/etc/rc.d$ Starting mysqld daemon with databases from /usr/local/var
STOPPING server from pid file /usr/local/var/TGO.pid
050309 13:39:41 mysqld ended

and when i run mysql it says cannot connet to localhost

thats pretty much the sum of my problems and its errors... i have got all the things working on slack i wanted to except for this

From what I'm seeing that's not Slackware official package of MySQL. Try getting it from some mirror because the instructions they gave you apply to it, not to a custom installation.

Did you do su - mysql or just su mysql?
I think you have to do su - mysql