| View previous topic :: View next topic |
| Author |
Message |
zeuz
Tux's lil' helper
Joined: 26 May 2004
Posts: 140
Location: Sweden
|
 Posted: Sat Sep 04, 2004 12:28 pm Post subject: MySQL problems |
 |
|
Hi, I just emerged mysql, but i can't get it to work...
'mysql test' results this:
| Code: | | ERROR 2002: Can't connect to local MySQL server trough socket '/var/run/mysqld/mysqld.sock' (2) |
Not sure on what to do... :-\ |
|
| Back to top |
|
 |
steveb
Advocate
Joined: 18 Sep 2002
Posts: 4564
|
| Posted: Sat Sep 04, 2004 2:01 pm Post subject: |
|
|
did you configure mysql?
did you started mysql?
cheers
SteveB |
|
| Back to top |
|
|
zeky
Guru
Joined: 24 Feb 2003
Posts: 470
Location: Vukojebina, Europe
|
| Posted: Sat Sep 04, 2004 3:09 pm Post subject: Re: MySQL problems |
|
|
| zeuz wrote: | Hi, I just emerged mysql, but i can't get it to work...
'mysql test' results this:
| Code: | | ERROR 2002: Can't connect to local MySQL server trough socket '/var/run/mysqld/mysqld.sock' (2) |
Not sure on what to do... :-\ |
After installing MySQL do:
0) after emerge mysql, you have to run:
| Code: | | ebuild /var/db/pkg/dev-db/mysql-4.0.20-r1/mysql-4.0.20-r1.ebuild config |
(Replace mysql version with the one you've emerged)
1) /etc/init.d/mysql start
2) mysqladmin -u root -password 'your_new_sql_password' (you need this to set a root pass for MySQL)
3) enjoy 
p.s.: you might wanna have phpmyadmin or webmin for configuring your SQL databases... just a thought.
EDIT: injected nr.0), just in case
_________________
Beat your dick like it owes you money |
|
| Back to top |
|
|
zeuz
Tux's lil' helper
Joined: 26 May 2004
Posts: 140
Location: Sweden
|
| Posted: Sat Sep 04, 2004 11:39 pm Post subject: |
|
|
Thanks for the answers! 
| Code: | | mysqladmin -u root -password 'your_new_sql_password' |
results in:
| Code: | mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES) |
I did set a password in the /etc/mysql/my.cnf and i'm using the same when trying the above...
Edit:
Followed this, and it worked!
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html |
|
| Back to top |
|
|
zeky
Guru
Joined: 24 Feb 2003
Posts: 470
Location: Vukojebina, Europe
|
| Posted: Sun Sep 05, 2004 2:16 pm Post subject: |
|
|
Very good 
Best regard to your beautiful country
_________________
Beat your dick like it owes you money |
|
| Back to top |
|
|
|
Networking & Security
