[root@freebsd ~]# /usr/local/etc/rc.d/mysql-server start[root@freebsd ~]# mysqlERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)學(xué)習Freebsd過(guò)程中的一些小技巧作者:未知 時(shí)間:2005-09-13 22:50 出處:Blog.ChinaUnix.net 責編:My FAQ摘要：學(xué)習Freebsd過(guò)程中的一些小技巧mysql 起動(dòng)錯誤解決辦法- -Access denied for user‘‘@‘localhost‘ to database ‘mysql‘ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘第一次安裝運行以下一句，產(chǎn)生數據庫文件/usr/local/bin/mysql_install_dbchown -R mysql /var/db/mysql啟動(dòng)mysql/usr/local/bin/mysqld_safe &mysql 起動(dòng)錯誤解決辦法- -Access denied for user‘‘@‘localhost‘ to database ‘mysql‘ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘第一次安裝運行以下一句，產(chǎn)生數據庫文件/usr/local/bin/mysql_install_dbchown -R mysql /var/db/mysql啟動(dòng)mysql/usr/local/bin/mysqld_safe &=====================================apache啟動(dòng)# /usr/local/sbin/apachectl start可以在任何時(shí)候使用下面的命令來(lái)停止服務(wù)：# /usr/local/sbin/apachectl stop當由于某種原因修改了配置文件之后， 需要重啟服務(wù)器：# /usr/local/sbin/apachectl restart========================================請問(wèn)你裝的是什么版本？如果是5.4的話(huà)，ssh默認是不打開(kāi)的。需要在/etc/rc.conf里面添加sshd_enable="YES"才行的。用SecureCRT 4.1登陸時(shí)設置Primary的時(shí)候設為keyboard就行了。5.4的驗證方式不能用password[/img]確認/etc/ssh/sshd_config里面下列三行前無(wú)#Port 22Protocol 2PasswordAuthentication yes=======================================前幾天有個(gè)帖子有說(shuō)如何不重啟動(dòng)而使網(wǎng)絡(luò )參數修改生效的方法。/etc/netstart restart================================================最簡(jiǎn)單的用系統自帶的ftpdvi /etc/inetd.conf把 ftpd前的#去掉存盤(pán)退出。(ipv6你應該用不上第二個(gè)ftpd的#你就不用去了)如果你系統里原先沒(méi)有啟動(dòng)inetd的話(huà)就用#inetd啟動(dòng)守護進(jìn)程inetd如果你已經(jīng)啟動(dòng)過(guò)了inetd就用 #killall -HUP inetd 從啟動(dòng)inetd給他們一個(gè)賬號就可以連上你的機器了，更具體的man ftpd。如果要inetd在下次隨系統啟動(dòng)編輯/etc/rc.conf加入inetd_enable="YES"如果你原先有了就不用再加了。當然ports里還提供豐富的ftpd 比如vsftpd pureftpd，配置都不麻煩。=============================================================如果您知道一個(gè)port的準確名字， 但需要知道在哪個(gè)類(lèi)別里面能找到它例如:# whereis lsoflsof: /usr/ports/sysutils/lsof還有另外的一個(gè)尋找您需要的port的方法--是用ports collecton 內嵌的搜索機制。要使用這個(gè)搜索, 您需要先到 /usr/ports目錄下面。在那個(gè)目錄里面， 運行make search name=program-name， program-name 就是您想尋找的程序名字。 舉個(gè)例子，如果您想找 lsof：# cd /usr/ports# make search name=lsofPort: lsof-4.56.4Path: /usr/ports/sysutils/lsofInfo: Lists information about open files (similar to fstat(1))Maint: obrien@FreeBSD.orgIndex: sysutilsB-deps:R-deps:================================================================ports安裝軟件定位到軟件ports目錄make install clean指定安裝目錄# make PREFIX=/usr/home/example/local install卸載make deinstall＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝查找文件find / -name *tbz＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝將pkg_add -r 的下載地址改成ftp://ftp.freebsdchina.orgbash shell#export PACKAGEROOT="
Fedora8啟動(dòng)mysql 報錯：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已經(jīng)啟動(dòng).另外看看是不是權限問(wèn)題.2、確定你的mysql.sock是不是在那個(gè)位置，mysql -u 你的mysql用戶(hù)名 -p -S /var/lib/mysql/mysql.sock3、試試：service mysqld start4、如果是權限問(wèn)題，則先改變權限 #chown -R mysql:mysql /var/lib/mysql[root@localhost ~]# /etc/init.d/mysqld start啟動(dòng) MySQL： [ 確定 ][root@localhost ~]# mysql -uroot -pERROR 2002 (HY000): Can‘t connect to localMySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)原因是，/var/lib/mysql 的訪(fǎng)問(wèn)權限問(wèn)題。shell> chown -R mysql:mysql /var/lib/mysql接著(zhù)啟動(dòng)服務(wù)器shell> /etc/init.d/mysql start服務(wù)器正常啟動(dòng)后察看 /var/lib/mysql 自動(dòng)生成mysql.sock文件。但是我的問(wèn)題仍然沒(méi)有得到解決。問(wèn)題終于解決：方法： 修改/etc/my.conf:[mysqld]datadir=/usr/local/mysql/datasocket=/var/lib/mysql/mysql.sock[mysql.server]user=mysqlbasedir=/usr/local/mysqlIf 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 as:[client]socket=/var/lib/mysql/mysql.sock發(fā)現依舊如此，運行/etc/init.d/mysql start報錯： Starting MySQLCouldn‘t find MySQL manager or server是mysqld服務(wù)沒(méi)啟，運行/usr/local/mysql/bin/mysqld_safe &問(wèn)題解決。Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=20399882006-11-27 11:06 banyaoFB6.2rc1下MYsQL啟動(dòng)出錯（已解決）[code]root@yao[/usr/ports/databases/mysql51-server]# make install===> mysql-server-5.1.11 cannot install: MySQL versions mismatch: mysql50-client is installed and wanted version is mysql51-client.*** Error code 1Stop in /usr/ports/databases/mysql51-server.root@yao[/usr/ports/databases/mysql51-server]#root@yao[/usr/ports/databases/mysql50-server]# make installroot@yao[/usr/ports/databases/mysql50-server]# /usr/local/etc/rc.d/mysql-server startStarting mysql.root@yao[/usr/ports/databases/mysql50-server]#root@yao[/usr/local/etc]# mysqlERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)root@yao[/usr/local/etc]# mysql -u root -pEnter password:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)root@yao[/usr/local/etc]# find /usr -name my.cnfroot@yao[/usr/local/etc]#[/code]這個(gè)是在另外一臺機器上遇到的問(wèn)題[code]phpMyAdmin - ErrorphpMyAdmin是在官方網(wǎng)上下載的最新版本2.9.1.1cp phpMyadmin /usr/local/www/apache/data目錄下有一個(gè)config.sample.inc.php文件,找把到教程中說(shuō)的config.inc.php 而且里面的內容也不想是config.inc.phpfirefox http://localhost/phpadmin瀏覽器中顯示:Fatal error: Call to undefined function preg_replace() in /usr/local/www/apache22/data/phpMyAdmin/libraries/sanitizing.lib.php on line 37[/code][[i] 本帖最后由 大大狗 于 2006-11-27 14:49 編輯 [/i]]2006-11-27 11:15 大大狗可能是mysql.sock的權限不夠2006-11-27 11:19 大大狗mysql.sock 它是被放在 /tmp/mysql.sock 臨時(shí)文件夾下的，所你可以重新啟動(dòng)一下系統就可以了reboot 在 mysql -u root -p2006-11-27 11:21 大大狗第二個(gè)問(wèn)題解決方法 [code]出現無(wú)法識別preg_replace函數的錯誤需要安裝pcre ， 位于 /usr/ports/devel/php5-pcre正則表達式的支持是由 PCRE（Perl Compatible Regular Expression）庫提供的，這是個(gè)開(kāi)放源代碼的軟件，作者為 Philip Hazel，版權屬于英國劍橋大學(xué)?？捎谝韵碌刂帆@得：ftp://ftp.csx.cam.ac.uk/[/code]2006-11-27 13:57 banyao謝謝,第一個(gè)問(wèn)題解決拉,第二個(gè)問(wèn)題,依然是不行,是不是phpMyAdmin缺少了個(gè)config.inc.php配置問(wèn)題?php5-extensions已經(jīng)ports上去了阿phpMyAdmin - ErrorCannot load session extension. Please check your PHP configuration.2006-11-27 14:01 大大狗/usr/ports/devel/[color=Blue]php5-pcre[/color] 這個(gè)已經(jīng)ports了嗎2006-11-27 14:13 banyao[quote]原帖由 [i]大大狗[/i] 于 2006-11-27 14:01 發(fā)表/usr/ports/devel/[color=Blue]php5-pcre[/color] 這個(gè)已經(jīng)ports了嗎 [/quote]已經(jīng)ports上了,2006-11-27 14:22 banyao重啟系統之后就可以了,謝謝 大大狗版主奇怪怎么我重啟服務(wù)不行,非得要重啟系統才可以http://bbs2.chinaunix.net/archiver/tid-861670.html作者 留言mylcx1028半仙注冊時(shí)間: 2007-05-17文章: 1
這兩天剛接觸FreeBSD,有問(wèn)題向大家請教 ^_^我想在系統里裝上mysql下面是安裝步驟:cd /usr/ports/databases/mysql51-server/makemake installmake cleancd work/mysql-5.1.11-betascripts/mysql_install_db出現以下信息:引用:Installing all prepared tablesFill help tablesTo start mysqld at boot time you have to copy support-files/mysql.serverto the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/local/bin/mysqladmin -u root password ‘new-password‘/usr/local/bin/mysqladmin -u root -h freeBSD.domain password ‘new-password‘See the manual for more instructions.NOTE: If you are upgrading from a MySQL <= 3.22.10 you should runthe /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not beable to use the new GRANT command!You can start the MySQL daemon with:cd /usr/local ; /usr/local/bin/mysqld_safe &Please report any problems with the /usr/local/bin/mysqlbug script!The latest information about MySQL is available on the web athttp://www.mysql.comSupport MySQL by buying support/licenses athttp://shop.mysql.commysql引用:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)mysql服務(wù)啟動(dòng)不了. : (引用:/usr/local/bin/mysqld_safe &也是和上面一樣的錯誤大家請指教.
mylcx1028 寫(xiě)到:這兩天剛接觸FreeBSD,有問(wèn)題向大家請教 ^_^我想在系統里裝上mysql下面是安裝步驟:cd /usr/ports/databases/mysql51-server/makemake installmake cleancd work/mysql-5.1.11-betascripts/mysql_install_db出現以下信息:引用:Installing all prepared tablesFill help tablesTo start mysqld at boot time you have to copy support-files/mysql.serverto the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/local/bin/mysqladmin -u root password ‘new-password‘/usr/local/bin/mysqladmin -u root -h freeBSD.domain password ‘new-password‘See the manual for more instructions.NOTE: If you are upgrading from a MySQL <= 3.22.10 you should runthe /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not beable to use the new GRANT command!You can start the MySQL daemon with:cd /usr/local ; /usr/local/bin/mysqld_safe &Please report any problems with the /usr/local/bin/mysqlbug script!The latest information about MySQL is available on the web athttp://www.mysql.comSupport MySQL by buying support/licenses athttp://shop.mysql.commysql引用:ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)mysql服務(wù)啟動(dòng)不了. : (引用:/usr/local/bin/mysqld_safe &也是和上面一樣的錯誤大家請指教. :oops:/usr/local/bin/mysql_install_db --user=mysql試試_________________如果大海能夠喚回曾經(jīng)的愛(ài)，就讓我用一生等待；如果深情往事你已不再留戀，就讓他隨風(fēng)飄遠；如果大海能夠帶走我的哀愁，就像帶走每條河流，所有受過(guò)的傷，所有流過(guò)的淚，我的愛(ài)，請全部帶走返回頁(yè)首
