Results 1 to 10 of 10
mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
If You Know Please Help i Get Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 06-06-2005 #1Just Joined!
- Join Date
- Apr 2005
- Posts
- 43
What Does This Mean I Cant Find English Help If I Google It
mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
If You Know Please Help i Get Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) every time i try do something... and when i go to /var/run/mysql/ there isnt anything there is that the problem...
Please help Me Out...
Cheer
Confused L33tLinuxN00b
- 06-06-2005 #2
Have you actually created a database? It's a bit counterintuitive, but mysql doesn't actually create a database when you install it...you have to do that after you install mysql or it won't start properly. Try:
so that you become the mysql user, thenCode:su mysq
to create a database. You may also need toCode:mysql_install_db
I also seem to remember reading in an earlier thread somewhere that in Slack you have toCode:chown mysql /var/lib/mysql/* chown mysql /var/lib/mysql/mysql/*
Code:ln -s /var/run/mysql/mysql.sock /tmp/mysql.sock
There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence.
- Jeremy S. Anderson
- 06-06-2005 #3Just Joined!
- Join Date
- Apr 2005
- Posts
- 43
chown: `/var/lib/mysql/ib_arch_log_0000000000': invalid user
and i am root
- 06-06-2005 #4
hmmm...try
Code:chown -R mysql /var/lib/mysql/* chgrp daemon /var/lib/mysql/*
There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence.
- Jeremy S. Anderson
- 06-06-2005 #5Just Joined!
- Join Date
- Apr 2005
- Posts
- 43
soz typed wrong thing for chown... its getting further... its getting ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) now
- 06-06-2005 #6
Try
Code:mysql -u root
There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence.
- Jeremy S. Anderson
- 06-06-2005 #7Just Joined!
- Join Date
- Apr 2005
- Posts
- 43
/usr/bin# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
- 06-06-2005 #8
You may have to create your root mysql password; try the following:
that will set the root passwordCode:mysqladmin -u root password
now, add a new user:
Code:mysql -u root -p
There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence.
- Jeremy S. Anderson
- 06-08-2005 #9Just Joined!
- Join Date
- Apr 2005
- Posts
- 43
Yay It Woked Thank You So Much
- 06-08-2005 #10
Glad to hear you got it working. Have fun
There are two major products that come out of Berkeley: LSD and UNIX. We don't believe this to be a coincidence.
- Jeremy S. Anderson


Reply With Quote
