Mysql solution in FreeBSD Environment

I have sorted out some solutions to the Mysql problem in the FreeBSD environment for your reference!

1. An error occurred while modifying the root user password:

# Mysqladmin-uroot-p password 'newpassword'

Enter password:

Mysqladmin: connect to server at 'localhost' failed

Error: 'Access denied for user' root' @ 'localhost' (using password: YES )'

Solution

#/Etc/init. d/mysql stop

# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &

# Mysql-u root mysql

Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';

Mysql> flush privileges;

Mysql> quit

#/Etc/init. d/mysql restart

# Mysql-uroot-p

Enter password: <Enter the new password newpassword>

Mysql>

Solve the problem!

2. An error occurred while starting Mysql.

Prompt: Can't connect to local MySQL server through socket

Reprinted: http://pchome.blog.enorth.com.cn/article/221219.shtml

Test is not performed.

Mysql startup error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2)

1. Check/etc/rc. d/init. d/mysqld status to see if m y s q l has been started.

Check whether the permission is correct.

2. Check whether your mysql. sock is in that location,

Mysql-u your mysql username-p-S/var/lib/mysql. sock

3. Try: service mysqld start

4. If the permission problem occurs, change the permission first # chown-R mysql: mysql/var/lib/mysql

[Root @ localhost ~] #/Etc/init. d/mysqld start

Start MySQL: [OK]

[Root @ localhost ~] # Mysql-uroot-p

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql. sock' (2)

The reason is that the access permission of/var/lib/mysql is incorrect.

Shell> chown-R mysql: mysql/var/lib/mysql

Start the server.

Shell>/etc/init. d/mysql start

After the server is started normally, check/var/lib/mysql to automatically generate the mysql. sock file.

However, my problem is still not solved.

The problem is finally solved:

Method: Modify/etc/my. conf:

[Mysqld]

Datadir =/usr/local/mysql/data

Socket =/var/lib/mysql. sock

[Mysql. server]

User = mysql

Basedir =/usr/local/mysql

If there is not currently a section called [client], add one at the bottom of the file and copy the socket = line under the [mysqld] section such:

[Client]

Socket =/var/lib/mysql. sock

The error "Starting MySQLCouldn't find mysql manager or server" is returned when you run/etc/init. d/MySQL start.

If the mysqld service is not enabled, run/usr/local/mysql/bin/mysqld_safe &

Solve the problem.