Set phpmyaddmin

Aplikasi-aplikasi diubuntu: • Aplikasi Grafis •
Aplikasi Internet •
Aplikasi Office •
Aplikasi Sound & Video •
Aplikasi Programming
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Set phpmyaddmin

Postby godjER » 31 Jan 2011, 12:41

agan2 yg terhormat..
gmana ya cara login di phpmyadmin lampp? mohon bantuannya..dari seorang pengguna baru ..Tks
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 14:53

godj wrote:agan2 yg terhormat..
gmana ya cara login di phpmyadmin lampp? mohon bantuannya..dari seorang pengguna baru ..Tks


buka browser, terus di address nya ketik

Code: Select all

http://localhost/phpmyadmin
, masukin user & password databasenya (MySQL biasanya)
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 15:18

gini bos..
#2002 Cannot log in to the MySQL server


??
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 15:23

ganti password MySQLnya dah coba? dari terminal.
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 15:29

wah ane masih bingung Gan pake linux...bnr2 newbie
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 15:33

misal user mysqlnya yg dibuat namanya root dan tanpa password host nya localhost, buka terminal terus ketik

Code: Select all

mysql -u root -p


Enter

abis itu akan muncul

Code: Select all

mysql>


terus ketik

Code: Select all

SET PASSWORD FOR root@localhost=PASSWORD('yourpass');
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 15:39

ok Gan...ntar tak cobane..mash di luar neh...pake Weduz gembez je...tks
:D
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 17:25

gini Gan

fajar@fajar-laptop:~$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


gimana y?
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 17:28

klo kayak gitu berarti root nya udah punya password, nah disamping -p isi passwordnya...
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 17:40

godj wrote:gini Gan

fajar@fajar-laptop:~$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)


gimana y?


recover password root nya mysql dulu, caranya ada disini
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 18:07

bingung Gan...
# /etc/init.d/mysql stop

tu perintah di terminal gmana y?masih buta soal linux Gan
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 18:16

godj wrote:bingung Gan...
# /etc/init.d/mysql stop

tu perintah di terminal gmana y?masih buta soal linux Gan


yang diketik diterminal yg depannya ada # (pagar), namun sewaktu diketik tanda # jangan diketik, jadi yg diketik

Code: Select all

/etc/init.d/mysql stop


stop itu perintahnya,
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 18:30

fajar@fajar-laptop:~$ /etc/init.d/mysql stop
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql


itu Gan..gmana?
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 18:44

jalaninnya udah pake user root kan atau pake sudo?

Code: Select all

sudo /etc/init.d/mysql stop


kalo g bisa juga, coba jalanin pake yg disaranin tadi

Code: Select all

sudo service mysql stop


atau

Code: Select all

sudo stop mysql
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 18:54

iya Gan, hasile tetep:

fajar@fajar-laptop:~$ sudo /etc/init.d/mysql stop
[sudo] password for fajar:
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql

kalo pake :
fajar@fajar-laptop:~$ sudo service mysql stop
stop: Unknown instance:
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 19:07

coba ketik diterminal

Code: Select all

ps ax | grep mysql


buat liat mysql running apa tidak.
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 31 Jan 2011, 19:18

fajar@fajar-laptop:~$ ps ax | grep mysql
20589 pts/2 S+ 0:00 grep --color=auto mysql
User avatar
RamBook
Posts: 125
Joined: 26 Jan 2011, 23:05
Contact:

Re: Set phpmyaddmin

Postby RamBook » 31 Jan 2011, 19:36

Code: Select all

kill mysql


abis itu cek lagi pake

Code: Select all

px ax | grep mysql
kalo udah g ada lanjutin step berikutnya buat recover password mysql
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 01 Feb 2011, 12:00

fajar@fajar-laptop:~$ kill mysql
bash: kill: mysql: arguments must be process or job IDs
fajar@fajar-laptop:~$


:( :(

gtu Gan
User avatar
godjER
Posts: 93
Joined: 29 Jan 2011, 17:19
Location: Yogyakarta
Contact:

Re: Set phpmyaddmin

Postby godjER » 01 Feb 2011, 14:05

Gan...dah SOLVED...makasih banyaakkkk


:D

Return to “Aplikasi Ubuntu”

Who is online

Users browsing this forum: No registered users and 11 guests