I Receive The Error "cannot Load Mysql Extension,

cdR · March 2, 2005

hi,

aku try install phpmyadmin dalam linux fedora core. lepas setting config.inc.php die suruh try run n buler aku run aku dapat error nie

[1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.
Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

nak buat aper ek? aku ader tertinggal somthing ke???

oshiri · March 2, 2005

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.

Dah install?

cdR · March 3, 2005

dah la..

ok aku dah dapat solution utk masalah tu.

kene masuk folder /etc/php.ini

pastu kene masuk dalam Dynamic Extensions pastu buang : kat line extension=mysql.so

ok. skrang dah dapat tapi biler load kuar error

"#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

pastu aku pening kepala balik.. cari2 aku dapat satu solution..

kene tukar user ngan group so kene taip kat terminal

chown -R mysql /var/lib/mysql/*

chgrp deamon /var/lib/mysql/*

tapi yg nie aku x try lagi.. jap lagi aku try...

ader komen ke?

oshiri · March 3, 2005

pastu kene masuk dalam Dynamic Extensions pastu buang : kat line extension=mysql.so

Yg ni aku tak tau la.........sebab aku punya setup tak payah pulak buang line tu.

Boleh ke buang line tu........phpmyadmin bukan nak guna module mysql?

Aku guna php.ini default aje.

"#2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

Ni error biasa kalo ko tak run mysql punya service.

cdR · March 3, 2005

cubaan terbaru gagal..

aku dah check kat services mmg mysql dah up tapi kenapa ye.. check kat services kan.

tq.

oshiri · March 3, 2005

Cuba run ps ax.........tengok mysql ada ke tak?

cdR · March 4, 2005

ps ax tu aper?

jap aku usar kat google.

oshiri · March 4, 2005

PS tu command linux..........ringkas bagi Process Status.

Ko run command ps ax dalam konsole............dia akan senarai kan semua process yg running dalam system ko.

Jadi ko boleh tengok la apa yg running dan apa yg tak running.

Jadi ko boleh check samada mysql ko betul-betul running atau tak kat background.

Cth:

8579 ? S 0:02 konsole [kdeinit] konsole

8582 pts/1 Ss 0:00 /bin/bash

9129 pts/1 S 0:00 bash

10662 pts/1 S 0:00 /bin/sh /usr/bin/mysqld_safe

10698 pts/1 S<l 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid

10699 pts/1 S 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld

10726 pts/1 R+ 0:00 ps ax

atau ko boleh run:

ps ax -f

utk senaraikan process status berserta UID/siapa yg run prcess tu.

Edited March 4, 2005 by oshiri

cdR · March 4, 2005

thanks u... aku check jap.

cdR · March 4, 2005

dah ckeck. mmg x de.. so aku dah check balik.. aku kene install pakage dulu. nanti aku update.

cdR · March 7, 2005

Still x jalan la.. dapat error yg sama

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

aku dah buntu dah... aku dah install pakage mysql ngan dah upkan kat service tapi x jalan2 gak.. biler chack pakai ps ax still x run service tu... aper nak buat lagi ek.. kat bawah nie hasil dari ps ax server aku... tgk kan maner tau aku ader buat silap ke.

PID TTY STAT TIME COMMAND
1 ? S 0:12 init [5]
2 ? SW 0:00 [swapper]
3 ? SW 0:00 [swapper]
4 ? SW 0:00 [swapper]
5 ? SW 0:00 [swapper]
6 ? SW 0:00 [keventd]
7 ? SWN 0:00 [ksoftirqd/0]
8 ? SWN 0:00 [ksoftirqd/1]
9 ? SWN 0:00 [ksoftirqd/2]
10 ? SWN 0:00 [ksoftirqd/3]
12 ? SW 0:00 [bdflush]
11 ? SW 0:05 [kswapd]
13 ? SW 0:05 [kupdated]
14 ? SW 0:00 [mdrecoveryd]
20 ? SW 0:00 [ahc_dv_0]
21 ? SW 0:00 [scsi_eh_0]
24 ? SW 0:02 [kjournald]
90 ? SW 0:00 [khubd]
1377 ? SW 0:00 [kjournald]
1378 ? SW 0:09 [kjournald]
1710 ? S 0:01 syslogd -m 0
1714 ? S 0:00 klogd -x
1725 ? S 0:53 irqbalance
1743 ? S 0:00 portmap
1763 ? S 0:00 rpc.statd
1905 ? S 0:00 /usr/sbin/sshd
1921 ? S 0:00 xinetd -stayalive -pidfile /var/run/xinetd.pid
1932 ? S 0:00 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf
1955 ? S 0:24 sendmail: accepting connections
1964 ? S 0:00 sendmail: Queue runner@01:00:00 for /var/spool/client 1975 ? S 0:19 gpm -m /dev/mouse -t ps/2
1997 ? S 0:00 crond
2021 ? S 0:00 xfs -droppriv -daemon
2040 ? S 0:00 /usr/sbin/atd
2050 ? S 0:00 dbus-daemon-1 --system
2070 tty1 S 0:00 /sbin/mingetty tty1
2071 tty2 S 0:00 /sbin/mingetty tty2
2072 tty3 S 0:00 /sbin/mingetty tty3
2073 tty4 S 0:00 /sbin/mingetty tty4
2074 tty5 S 0:00 /sbin/mingetty tty5
2075 tty6 S 0:00 /sbin/mingetty tty6
2076 ? S 0:00 /usr/bin/gdm-binary -nodaemon
2125 ? S 0:00 /usr/bin/gdm-binary -nodaemon
2126 ? S 93:35 /usr/X11R6/bin/X :0 -audit 0 -auth /var/gdm/:0.Xauth
26332 ? S 0:00 smbd -D
26336 ? S 0:14 nmbd -D
30148 ? S 0:00 /usr/bin/postmaster -p 5432
30149 ? S 0:00 postgres: stats buffer process
30150 ? S 0:00 postgres: stats collector process
31615 ? S 0:01 cupsd
4023 ? S 0:46 smbd -D
4055 ? S 0:00 /usr/bin/gnome-session
4116 ? S 0:00 /usr/bin/ssh-agent /etc/X11/xinit/Xclients
4126 ? S 0:01 /usr/libexec/gconfd-2 5
4130 ? S 0:00 /usr/libexec/bonobo-activation-server --ac-activate - 4132 ? S 0:01 /usr/bin/metacity --sm-client-id=default1
4134 ? S 0:00 gnome-settings-daemon --oaf-activate-iid=OAFIID:GNOME 4167 ? S 0:01 gnome-panel --sm-client-id default2
4173 ? S 0:01 nautilus --no-default-window --sm-client-id default3
4176 ? S 0:00 magicdev --sm-client-id default4
4178 ? S 0:00 eggcups --sm-client-id default6
4180 ? S 0:00 pam-panel-icon --sm-client-id default0
4182 ? RN 0:07 /usr/bin/python /usr/bin/rhn-applet-gui --sm-client-i 4183 ? S 0:00 /sbin/pam_timestamp_check -d root
4188 ? S 0:00 /usr/libexec/mapping-daemon
4190 ? S 0:00 /usr/libexec/notification-area-applet --oaf-activate- 4192 ? S 0:02 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID: 4196 ? S 0:00 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GN 4249 ? S 0:00 fam
4589 ? S 0:00 /usr/sbin/httpd
4592 ? S 0:00 /usr/sbin/httpd
4593 ? S 0:00 /usr/sbin/httpd
4594 ? S 0:00 /usr/sbin/httpd
4595 ? S 0:00 /usr/sbin/httpd
4596 ? S 0:00 /usr/sbin/httpd
4597 ? S 0:00 /usr/sbin/httpd
4598 ? S 0:00 /usr/sbin/httpd
4599 ? S 0:00 /usr/sbin/httpd
4641 ? S 0:00 /usr/sbin/httpd
4642 ? S 0:00 /usr/sbin/httpd
4643 ? S 0:00 /usr/sbin/httpd
4676 ? S 0:00 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf
4678 ? S 0:00 /usr/sbin/vsftpd /etc/vsftpd/vsftpd.conf
4713 ? S 0:10 /usr/lib/mozilla-1.4.1/mozilla-bin -UILocale en-US
4733 ? Z 0:00 [netstat <defunct>]
4735 ? S 0:00 /usr/bin/gnome-terminal
4736 ? S 0:00 gnome-pty-helper
4737 pts/0 S 0:00 bash
4765 pts/0 R 0:00 ps ax

oshiri · March 7, 2005

Mula-mula ko kena run mysql:

su

/etc/init.d/mysqld start

Tengok ada error tak? Kalo ada error ko check apa dia:

su

tail /var/log/messages

Aku ada baca.......masalah Fedora mysql dgn SELinux.

Coba ko buat camni:

su

rm -rf /var/lib/mysql

/usr/sbin/setenforce 0

/etc/init.d/mysqld start

/usr/sbin/setenforce 1

Kaedah kat atas tu utk temporary......disable selinux sebelum start mysql dan start selinux semula.

Kalo berjaya dgn cara tu.........ko boleh disable selinux dari mysql permanently:

Start menu--->System setting--->Security settings or security level--->SE Linux--->SELinux Service Protection--->Disable SELinux protection for mysqld daemon--->ok.............REBOOT.

Ko ada buat dia run masa boot tak?

rc-update add mysqld default

Edited March 7, 2005 by oshiri

cdR · March 7, 2005

tq Oshiri...

aku dah berjaya dengan bantuan ko.. tapi ader beberapa soklan.. dalam file config.inc.php tu mmg kene edit

1. Abselute URL

2. Username

3. Password

so aku edit la pastu kuar error x leh masuk. Login prob.. masalahnya biler die loginnyer.. so aku tukar user n pass default : "root" pass : "" baru boleh masuk..

nampaknyer kene creat password dalam phpmyadmin la..'

BTW thanks alot.

oshiri · March 7, 2005

aku dah berjaya dengan bantuan ko.. tapi ader beberapa soklan.. dalam file config.inc.php tu mmg kene edit
1. Abselute URL
2. Username
3. Password

Ko tak perlu edit apa-apa dalam config.inc.php.

Yang penting ko kena buat root dan pass untuk mysql.....itu aje.

Bila dah ada root dan password dia......baru la ko boleh masuk phpmyadmin dan create user.........dengan full previelage.

posenaz · July 28, 2006

A'kum..semu

sy sebenarnye baru dlm linux ni..skrg tgh guna Ubuntu.

sy tgh install web server and Mysql database. tp bila nak running phpmyadmin xleh la..sape2 leh bantu tak???

tolong la puas dah try tak leh.. nak gila dh nie

tlg para dewa2 linux bantu sy ni..

sy dapat msg ni la..

________________________________

cannot load mysql extension,

please check PHP Configuration

Documentation

_________________________________

Pleaseeeeeeeeeee........... help.

cikgureza · July 28, 2006

A'kum..semu
sy sebenarnye baru dlm linux ni..skrg tgh guna Ubuntu.
sy tgh install web server and Mysql database. tp bila nak running phpmyadmin xleh la..sape2 leh bantu tak???
tolong la puas dah try tak leh.. nak gila dh nie
tlg para dewa2 linux bantu sy ni..
sy dapat msg ni la..
________________________________
cannot load mysql extension,
please check PHP Configuration
Documentation
_________________________________
Pleaseeeeeeeeeee........... help.

Ubuntu version berapa? Rasanya kalau camtu, php either belum install, ataupun service php tu belum jln lagi..

Pergi synaptic dan type PHP5 kat search, pastu tick semua yg ada melibatkan php5 dan jugak php+mysql, pastu try legi..

posenaz · July 31, 2006

Ubuntu version berapa? Rasanya kalau camtu, php either belum install, ataupun service php tu belum jln lagi..
Pergi synaptic dan type PHP5 kat search, pastu tick semua yg ada melibatkan php5 dan jugak php+mysql, pastu try legi..

mmm...soory lambat reply,,

Ok Thanks cikgureza nanti sy try cara yg cikgureza bgtau tu..kalu tak dapat sy tanye lagi ek

A'kum...

TRUNASUCI · August 14, 2006

ok..

kalau dah setel tlg bagitau yer.. pasal nak close topic mana2 yg problem dah solve

selamat mencuba!

Sign In

I Receive The Error "cannot Load Mysql Extension,

Recommended Posts

cdR 0

Share this post

Link to post

Share on other sites

oshiri 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

oshiri 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

oshiri 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

oshiri 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

oshiri 0

Share this post

Link to post

Share on other sites

cdR 0

Share this post

Link to post

Share on other sites

oshiri 0

Share this post

Link to post

Share on other sites

posenaz 0

Share this post

Link to post

Share on other sites

cikgureza 5

Share this post

Link to post

Share on other sites

posenaz 0

Share this post

Link to post

Share on other sites

TRUNASUCI 15

Share this post

Link to post

Share on other sites

Join the conversation

Announcements

Browse

Activity