Tidak bisa install mysql server & client

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Tidak bisa install mysql server & client

Yoseph Handoko-2
Dear friends

saya newbie yang mau menginstall mysql untuk keperluan kuliah di laptop
saya.

saya sudah coba install lewat synaptic package manager atau lewat
terminal dengan perintah :

-----------------------------------
sudo apt-get install mysql-server
-----------------------------------

tetapi selalu tidak bisa terinstall dengan baik.

Pesan kesalahan yang terlihat adalah :

--------------------------------------
Reading package lists... Done
Building dependency tree... Done
Suggested packages:
  mysql-doc
The following NEW packages will be installed:
  mysql-client
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
6 not fully installed or removed.
Need to get 0B/413kB of archives.
After unpacking 1024kB of additional disk space will be used.

Prakonfigurasi paket ...
(Sedang membaca basis data ...154345 berkas dan direktori telah
terpasang.)
Sedang membuka paket mysql-client
(dari .../mysql-client_4.0.24-10ubuntu2_i386.deb) ...
Sedang menyetel libnet-daemon-perl (0.38-1) ...

Sedang menyetel libplrpc-perl (0.2017-1) ...

Sedang menyetel libdbi-perl (1.48-1) ...
Sedang menyetel libdbd-mysql-perl (2.9007-1) ...
Sedang menyetel mysql-admin (1.0.22a-1build3) ...

Sedang menyetel mysql-client (4.0.24-10ubuntu2) ...
Sedang menyetel mysql-server (4.0.24-10ubuntu2) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld...failed.
        Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!
-----------------------------------------------

saya lihat memang file /var/run/mysqld.sock tidak ada.

Mohon pencerahannya

Salam
Yoseph Handoko


--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

risiyanto budi
Yoseph Handoko wrote:

>Dear friends
>
>saya newbie yang mau menginstall mysql untuk keperluan kuliah di laptop
>saya.
>
>saya sudah coba install lewat synaptic package manager atau lewat
>terminal dengan perintah :
>
>-----------------------------------
>sudo apt-get install mysql-server
>-----------------------------------
>
>tetapi selalu tidak bisa terinstall dengan baik.
>
>Pesan kesalahan yang terlihat adalah :
>
>--------------------------------------
>Reading package lists... Done
>Building dependency tree... Done
>Suggested packages:
>  mysql-doc
>The following NEW packages will be installed:
>  mysql-client
>0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
>6 not fully installed or removed.
>Need to get 0B/413kB of archives.
>After unpacking 1024kB of additional disk space will be used.
>
>Prakonfigurasi paket ...
>(Sedang membaca basis data ...154345 berkas dan direktori telah
>terpasang.)
>Sedang membuka paket mysql-client
>(dari .../mysql-client_4.0.24-10ubuntu2_i386.deb) ...
>Sedang menyetel libnet-daemon-perl (0.38-1) ...
>
>Sedang menyetel libplrpc-perl (0.2017-1) ...
>
>Sedang menyetel libdbi-perl (1.48-1) ...
>Sedang menyetel libdbd-mysql-perl (2.9007-1) ...
>Sedang menyetel mysql-admin (1.0.22a-1build3) ...
>
>Sedang menyetel mysql-client (4.0.24-10ubuntu2) ...
>Sedang menyetel mysql-server (4.0.24-10ubuntu2) ...
>Stopping MySQL database server: mysqld.
>Starting MySQL database server: mysqld...failed.
>        Please take a look at the syslog.
>  
>
coba ikuti perintah ini:

Please take a look at the syslog.


---
Salam
Aris

--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

Yoseph Handoko-2
Ini isi dari syslog, (terus terang saya bingung apa yang harus
dilakukan)

Dec 12 08:56:32 localhost mysqld_safe[11268]: Preparing db table
Dec 12 08:56:32 localhost mysqld_safe[11268]: Preparing host table
Dec 12 08:56:32 localhost mysqld_safe[11268]: Preparing user table
Dec 12 08:56:32 localhost mysqld_safe[11268]: Preparing func table
Dec 12 08:56:32 localhost mysqld_safe[11268]: Preparing tables_priv
table
Dec 12 08:56:32 localhost mysqld_safe[11268]: Preparing columns_priv
table
Dec 12 08:56:32 localhost mysqld_safe[11268]: Installing all prepared
tables

Dec 12 08:56:32 localhost mysqld_safe[11268]: 051212
8:56:32 /usr/sbin/mysqld: Shutdown Complete
Dec 12 08:56:32 localhost mysqld_safe[11268]:
Dec 12 08:56:32 localhost mysqld_safe[11268]:
Dec 12 08:56:32 localhost mysqld_safe[11268]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Dec 12 08:56:32 localhost mysqld_safe[11268]: To do so, start the
server, then issue the following commands:
Dec 12 08:56:32 localhost mysqld_safe[11268]: /usr/bin/mysqladmin -u
root password 'new-password'
Dec 12 08:56:32 localhost mysqld_safe[11268]: /usr/bin/mysqladmin -u
root -h yosephhandoko password 'new-password'
Dec 12 08:56:32 localhost mysqld_safe[11268]: See the manual for more
instructions.
Dec 12 08:56:32 localhost mysqld_safe[11268]:
Dec 12 08:56:32 localhost mysqld_safe[11268]: Please report any problems
with the /usr/bin/mysqlbug script!
Dec 12 08:56:32 localhost mysqld_safe[11268]:
Dec 12 08:56:32 localhost mysqld_safe[11268]: The latest information
about MySQL is available on the web at
Dec 12 08:56:32 localhost mysqld_safe[11268]: http://www.mysql.com
Dec 12 08:56:32 localhost mysqld_safe[11268]: Support MySQL by buying
support/licenses at https://order.mysql.com
Dec 12 08:56:32 localhost mysqld_safe[11268]:
Dec 12 08:56:32 localhost mysqld_safe[11293]: 051212
8:56:32 /usr/sbin/mysqld: Shutdown Complete
Dec 12 08:56:32 localhost mysqld_safe[11293]:
Dec 12 08:56:32 localhost mysqld_safe[11298]: 051212
8:56:32 /usr/sbin/mysqld: Shutdown Complete
Dec 12 08:56:32 localhost mysqld_safe[11298]:

Dec 12 08:56:32 localhost mysqld_safe[11367]: started
Dec 12 08:56:32 localhost mysqld[11371]: /usr/sbin/mysqld-max: error
while loading shared libraries: libstdc++-libc6.2-2.so.3: cannot open
shared object file: No such file or directory
Dec 12 08:56:32 localhost mysqld_safe[11373]: ended
D
Dec 12 08:56:38 localhost /etc/init.d/mysql[11438]: 0 processes alive
and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
resulted in
Dec 12 08:56:38 localhost /etc/init.d/mysql[11438]:
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Dec 12 08:56:38 localhost /etc/init.d/mysql[11438]: error: 'Can't
connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)'
Dec 12 08:56:38 localhost /etc/init.d/mysql[11438]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Dec 12 08:56:38 localhost /etc/init.d/mysql[11438]:


Salam
Yoseph Handoko


--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

Yoseph Handoko-2
Dear friends

Sekarang saya sudah bisa install mysql server & client
cuma saya kok gak bisa mengaktifkannya,
kalau saya ketik

# /etc/init.d/mysqld start

maka pesan yang muncul adalah
bash: /etc/init.d/mysqld: No such file or directory

kalau saya ketik

# mysql

pesan yang muncul adalah :
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

saya cek memang file mysqld.sock tidak ada

Mohon bantuannya
Salam
Yoseph Handoko


--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

Yoseph Handoko-2
Dear friends

sudah bisa
ternyata saya cukup sebagai superuser saja
jadi saya tambahkan perintah sudo didepannya

Salam
Yoseph Handoko



--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

Alvonsius Albert
In reply to this post by Yoseph Handoko-2

> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket

Kayanya errornya di sini nih. Coba perhatikan di interfaces anda, dan coba
ping ke localhost. Bisa nggak ping-nya jalan. Kalau tidak jalan, coba
diaktifkan loopback interfacesnya di /etc/network/interfaces

# The loopback network interface
auto lo
iface lo inet loopback

Kalau memang anda menyetel IP address anda tidak bisa untuk loopback, coba
ubah setting host anda  di /etc/mysql/my.cnf pada isian berikut:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address           = 127.0.0.1  ---> diubah menjadi ...

bind-address            = 192.168.1.27

Keuntungan cara kedua yang saya kasi ini adalah bisa melakukan remote login ke
mesin anda dari mesin lain karena yang dijadikan referensi adalah IP anda
(CMIIW please)

Kemudian coba restart lagi mysql-nya.

Semoga berhasil ...

--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

risiyanto budi
In reply to this post by Yoseph Handoko-2
Yoseph Handoko wrote:

>Dear friends
>
>sudah bisa
>ternyata saya cukup sebagai superuser saja
>jadi saya tambahkan perintah sudo didepannya
>
>  
>
hehehe,
proses self learning yang cepat dari sodara yoseph,
SALUT!

ya gitu mas, kalo sudah berhasil,  ngomong di milis.

jangan seperti saya dulu, kalo dah bisa diem-diem saja hihihi :">.

--
Aris


--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

Alvonsius Albert
In reply to this post by Yoseph Handoko-2
On Monday 12 December 2005 10:17, Yoseph Handoko wrote:
> Dear friends
>
> Sekarang saya sudah bisa install mysql server & client
> cuma saya kok gak bisa mengaktifkannya,
> kalau saya ketik
>
> # /etc/init.d/mysqld start
>

Yang ada itu bukan /etc/init.d/mysqld tapi /etc/init.d/mysql

--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id
Reply | Threaded
Open this post in threaded view
|

Re: Tidak bisa install mysql server & client

Yoseph Handoko-2
Iya bener mestinya adalah /etc/init.d/mysql bukan /etc/init.d/mysqld
abis liat di tutorial kuliah sih hehehehe

salam
Yoseph Handoko


--
ubuntu-id mailing list
[hidden email]
http://lists.ubuntu.com/mailman/listinfo/ubuntu-id