LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-24-2011, 11:20 AM   #1
dragonetti
LQ Newbie
 
Registered: Sep 2011
Posts: 18

Rep: Reputation: Disabled
ubuntu server: change mysql port & phpmyadmin


I have 2 questions about changing the mysql port:

1)I changed my mysql port by editing the "my.cnf" file.
But there were 2 default "port 3306" entries.
One under "[mysqld]" and one under "[client]".
Do I change both entries, so the one under "[mysqld]" AND the one under "[client]"?

2)After changing the port, I installed phpmyadmin: "apt-get install phpmyadmin"
After installing phpmyadmin, which files must I edit in the phpmyadmin settings?
So far I have found these files which have port settings:
\etc\phpmyadmin\config-db.php
\etc\phpmyadmin\config.inc.php
\etc\dbconfig-common\phpmyadmin.conf

I'm working on a remote VPS, so I only can do it through terminal.

Thank you!!

Last edited by dragonetti; 11-24-2011 at 01:54 PM.
 
Old 11-24-2011, 07:25 PM   #2
goodhombre
Member
 
Registered: Mar 2010
Location: Ungheni, Rep. Moldova
Distribution: Ubuntu
Posts: 82

Rep: Reputation: 20
Hi,

1.
[mysql] section is for mysql clinent and [mysqld] section is for mysql server .
In order to change the port the server listens on you have to edit port value under [mysqld] .

2.
It should be : \etc\phpmyadmin\config.inc.php
 
1 members found this post helpful.
Old 11-24-2011, 07:42 PM   #3
dragonetti
LQ Newbie
 
Registered: Sep 2011
Posts: 18

Original Poster
Rep: Reputation: Disabled
@goodhombre

THANKS WORKED!!!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change ' to ' sign in ubuntu server rytec Linux - Software 5 06-10-2011 06:36 AM
MySQL (phpMyAdmin) & PHP iWant2Know Programming 5 08-24-2010 04:44 PM
mysql / phpmyadmin & fedora fuelinjection Linux - General 2 06-20-2005 11:28 PM
MySql & phpMyAdmin & mysqldump BaerRS Linux - Software 2 01-24-2003 10:05 AM
phpMyAdmin & MySQL Staz Linux - Software 0 09-26-2002 08:41 PM


All times are GMT -5. The time now is 12:31 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration