How To Config PhpMyAdmin
Aug 23, 2007
I am a newbie and now i am running a VPS account. I have some questions want to ask you
Where is the locate of phpMyAdmin?
I am running VPS server but get error when access to phpmyadmin.
Quote:
Wrong username/password. Access denied.
I created a user=root and passworld=xxx in my WHM.
How to find config.inc.php ?
- locate but error
Quote:
warning: locate: could not open database: /var/lib/slocate/slocate.db: No such file or directory
warning: You need to run the 'updatedb' command (as root) to create the database.
Please have a look at /etc/updatedb.conf to enable the daily cron job.
View 4 Replies
ADVERTISEMENT
Aug 23, 2007
I have a problem when i config config.inc.php file in my WHM . I don't know why share accounts can access to phpMyAdmin or create your database from cpanel .
This is a part of config.inc.php file
Quote:
/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfg['PmaNoRelation_DisableWarning'] = FALSE;
/**
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
* at least one server configuration uses 'cookie' auth_type, enter here a
* passphrase that will be used by blowfish. The maximum length seems to be 46
* characters.
*/
$cfg['blowfish_secret'] = '';
/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
// $cfg['Servers'][0]. You can disable a server config entry by setting host
// to ''. If you want more than one server, just copy following section
// (including $i incrementation) serveral times. There is no need to define
// full server array, just define values you need to change.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['ssl'] = false; // Use SSL for connecting to MySQL server?
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie)
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['SignonSession'] = ''; // Session to use for 'signon' auth method
$cfg['Servers'][$i]['SignonURL'] = ''; // URL where to redirect user to login for 'signon' auth method
$cfg['Servers'][$i]['LogoutURL'] = ''; // URL where to redirect user after logout
$cfg['Servers'][$i]['nopassword'] = FALSE; // Whether to try to connect without password
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed in left frame
// It may also be an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'pma_bookmark'
$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'pma_relation'
$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'pma_table_info'
$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf
// - leave blank if you don't want to use this
// DEFAULT: 'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] = ''; // table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'pma_column_info'
$cfg['Servers'][$i]['history'] = ''; // table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'pma_history'
$cfg['Servers'][$i]['designer_coords'] = ''; // table to store the coordinates for Designer
// - leave blank for no Designer feature
// DEFAULT: 'pma_designer_coords'
$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables
// are up to date. This prevents compatibility
// checks and thereby increases performance.
$cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login
$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use
= '';
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults
= array();
// If you have more than one server configured, you can set $cfg['ServerDefault']
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfg['ServerDefault'] *MUST* be
// set to that server.
$cfg['ServerDefault'] = 1; // Default server (0 = no default server)
/**
* Other core phpMyAdmin settings
*/
$cfg['MaxDbList'] = 100; // maximum number of db's displayed in left frame and databaes list
$cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database
$cfg['ForceSSL'] = FALSE; // whether to force using https
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
$cfg['MemoryLimit'] = 0; // maximum allocated bytes (0 for no limit)
$cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show
// locked tables (since MySQL 3.23.30)
$cfg['ShowSQL'] = TRUE; // show SQL queries as run
$cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users
$cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'
$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not
$cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds)
$cfg['LoginCookieStore'] = 0; // how long login cookie should be stored (in seconds)
$cfg['LoginCookieDeleteAll'] = TRUE; // whether to delete all login cookies on logout
$cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature
// or not
$cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries
// even if one of the queries failed
$cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on
// multiple-statement queries. See the libraries/import.php file for
// hardcoded defaults on how many queries a statement may contain!
$cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth
// Left frame setup
$cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the
// current tables in the left frame.
$cfg['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree
$cfg['LeftFrameDBSeparator'] = '_'; // the separator to sub-tree the select-based light menu tree
$cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes
// to split/nest tables into multiple categories
$cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting
// up tables by the above Separator
$cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame
$cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments
$cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_structure) instead of
// table/db names. Setting ShowTooltipAliasTB to 'nested' will only
// use the Aliases for nested descriptors, not the table itself.
$cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame
$cfg['LeftLogoLink'] = 'main.php'; // where should logo link point to
// (can also contain an external URL)
$cfg['LeftLogoLinkWindow'] = 'main'; // whether to open the linked page
// in the main window ('main')
// or in a new window ('new')
$cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame
$cfg['DisplayServersList'] = FALSE; // server choice as links
$cfg['DisplayDatabasesList'] = FALSE; // database choice in light as links
// In the main frame, at startup...
$cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in
// the pages about database details and table
// properties
$cfg['ShowPhpInfo'] = FALSE; // show php info link
$cfg['ShowServerInfo'] = TRUE; // show MySQL server information
$cfg['ShowChgPassword'] = FALSE; // show change password link
$cfg['ShowCreateDb'] = TRUE; // show create database form
$cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)
Some questions
--------------------------------------------------
$cfg['Servers'][$i]['controluser'] =?
$cfg['Servers'][$i]['controlpass'] =?
--------------------------------------------------
$cfg['Servers'][$i]['user'] =?
$cfg['Servers'][$i]['password'] =?
View 2 Replies
View Related
Mar 8, 2015
I installed Plesk on a VPS running on Ubuntu 14.04. When I try to open phpMyAdmin the following error message appears:
You probably did not create a configuration file. You might want to use the setup script to create one.
Error
MySQL said: cannot connect: invalid settings.
When I try to click on the setup script link another error message pops up:
Error in Processing Request
Error code: 404
Error text: Not Found
What do I have to do to make phpMyAdmin work?
View 1 Replies
View Related
Dec 3, 2008
i downloaded a copy of phpmyadmin and uploaded it to my hosting.. then i run mydomain.com/phpmyadmin/setup configured the server to my hosting IP address but it says i can't login using myusername@localhost do i need to do something on a cpanel mysql server to listen to the external phpmyadmin?
View 1 Replies
View Related
Jan 15, 2007
I've only messed around in php/mysql stuff on occasion, so I'm still new to it.
When I access domain.com/phpmyadmin and log in, I see two things that I believe are preventing my stuff from connecting and working properly.
**Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.
**The mbstring PHP extension was not found and you seem to be using a multibyte charset.
Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
View 4 Replies
View Related
Jul 18, 2009
I've just did the following on Ubuntu Server 9.03:
Code:
sudo apt-get install mysql-server
sudo apt-get install apache2
sudo apt-get install php5
sudo apt-get install php5-mysql
sudo apt-get install phpmyadmin
But when I say [url]-- it cannot be found..
I tried [url]as well, It cannot be found either.
View 2 Replies
View Related
Aug 12, 2009
I am using plesk and created one database from my control panel and also created a user to
access the database. Now my concern is how can I access phymyadmin. Is it possible to access
PHPMyadmin from Plesk? Or is there any other way to manage my database?
View 3 Replies
View Related
Dec 13, 2008
Anyone using phpMyAdmin for MySQL admin, you need to know about a newly discovered attack vector.
Here's the official announcement: [url]
The key to this is in their description, "A logged-in user can be subject of SQL injection through cross site request forgery. Several scripts in phpMyAdmin are vulnerable and the attack can be made through table parameter."
A logged in user... This attack is a combination of SQL injection through CSRF. In other words, you'd have to be logged into your phpMyAdmin program, hit a website setup for CSRF, and then the attacker could have access to your phpMyAdmin as you.
If there's interest here, I could write up a detailed description of CSRF and how to prevent this type of attack.
Just let me know...
You should upgrade immediately to either phpMyAdmin 2.9.11.4 or 3.1.1.0 or apply patch 12100.
View 9 Replies
View Related
Sep 16, 2008
I've got phpMyAdmin setup, but when I logout or try to browse a table I get 404 error. Everything is CHMOD as 755. Ideas? I'm also running off of LiteSpeed
View 3 Replies
View Related
Jun 10, 2008
i have a problme in the server .. that when any site try to login the phpmyadmin this message appears " #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
View 2 Replies
View Related
Jan 20, 2008
i m using DA server. i want to upgrade to latest version.
View 7 Replies
View Related
Dec 28, 2007
My PhpMyAdmin is not working properly.
Everytime I try to use it, it tells me:
"Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."
My PHP install is perfectly fine, and session support is enabled.
View 2 Replies
View Related
Feb 22, 2007
I've been struggling with getting phpMyAdmin to work on IIS7 for a long time. I've tried just about everything I can possibly think of, in the process, breaking both PHP and MySQL several times.
Ok...so my PHP and MySQL is working great now...but I still can't get phpMyAdmin to work. I get the following message :
Quote:
Cannot load mysql extension. Please check your PHP configuration. - Documentation
If you anyone has some advice, I will appreciate it.
I'm running :
PHP 5.1.2
MySQL 5
IIS7
Vista
View 0 Replies
View Related
May 27, 2007
Has anyone seen any docs on upgrading phpMyAdmin? And does it need to be done via SSH?
I'm on a MediaTemple (gs)...
View 1 Replies
View Related
May 20, 2007
I have a auction website using php and mySQL and categories are saved in database. When i tried to add new categories in Admin area such as: Đà Nẵng(Vietnamese) and when i saved, it displayed something funny like this:"ďà N&#ng". I have modified charset in myPhPadmin for the database and for categories table to uft-8, but it won't help.
View 4 Replies
View Related
Sep 4, 2007
Because phpmyadmin on powervps'directadmin doesnt support phpMyAdmin - 2.10.3 version, so I have to install it by my self. I read the instruction in here
[url]
But I dont understand.
First of all: How can I upload the file to directory /var/tmp?
2, when I type the command below, it did not work:
# cd /home/httpd/SSLSERVER-443/html
# tar zxvf /var/tmp/phpMyAdmin-2.7.0-pl1.tar.gz
# mv phpMyAdmin-2.7.0-pl1 phpMyAdmin
And the following commands did not work too.
I really need the version above to run my database. The current phpmyadmin does not support it and that why my database got error when I was trying to restore.
View 2 Replies
View Related
May 5, 2009
Server :
Code:
Intel C2Q Q9450
8196 MB DDR2 RAM
500 GB 7.200RPM
2000GB Transfer p/m
OS: CentOS 5.2
Code:
running a ipb forum site 2.3.4
current stats :
Our members have made a total of 245,827 posts
We have 14,673 registered members
Total number of topics is 75099
with atleast 150 members online + 200guests.
what would be the perfect my.cnf config for this kinda of a server? Im running litespeed.
View 4 Replies
View Related
Jan 3, 2008
I am trying to install a newer release of APC PHP cache on our server that runs RHES-4 and PHP 4.3.9
I installed version 3.0.14 some time ago and now cannot install the new v3.0.16. When I run ./configure I get this:
Quote:
[root@xxxx APC-3.0.16]# ./configure --enable-apc --enable-apc-mmap --with-apxs --with-php-config
configure: error: cannot run /bin/sh ./config.sub
The baffling thing is that I also cannot now reinstall 3.0.14 as it shows the same error.
I also get this error if I try to install XCache.
View 4 Replies
View Related
Jul 9, 2009
I found several requests in my error log which looks like someone was scanning my site for phpMyAdmin. This was a newly created subdomain. So I checked my main site and another subdomain and they also contained similar entries. Should I do something?
[Fri Jul 03 03:23:16 2009] [error] [client 65.23.157.214] File does not exist: /var/www/vhosts/mydomain.com/subdomains/mysubdomain/httpdocs/phpMyAdmin
[Fri Jul 03 03:23:16 2009] [error] [client 65.23.157.214] File does not exist: /var/www/vhosts/mydomain.com/subdomains/mysubdomain/httpdocs/phpmyadmin
[Fri Jul 03 03:23:16 2009] [error] [client 65.23.157.214] File does not exist: /var/www/vhosts/mydomain.com/subdomains/mysubdomain/httpdocs/pma ...
View 14 Replies
View Related
Jun 28, 2009
I host my own website on my computer (Mac mini Mac OS X 10.5.7)
I am running Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7l DAV/2 PHP/5.2.9 - MySQL 5.1.35 - phpMyAdmin 3.2.0
I recently made MySQL and phpMyAdmin upgrades.
Before the upgrades, when performing a name search in the main table of my DB, if the query returned no result, the right frame displayed the result and the usual content of the Search Tab for performing a new search.
Now, the right frame displays a blank page with only the mention of ServerName - DatabaseName - TableName
Is this a bug or a new (bad) feature in phpMyAdmin 3.2.0?
View 0 Replies
View Related
Mar 29, 2009
how can install mbstring for phpmyadmin in lxadmin?
View 3 Replies
View Related
Dec 24, 2008
I rent a vps and currenly running on CentOS. I already setup 2 domain using VirtualHost and wondering how I can configure for each domain can access only 1 phpmyadmin directory
e.g :
example.com/phpmyadmin
example1.com/phpmyadmin
for now I manage to to it manually without using any cPanel or other tools.. cost saving , just want to learn to setup for myself.
View 3 Replies
View Related
May 7, 2008
i am on an VPS , i want to know how different vanilla mysql is from mysql
since i got vanilla mysql , and want to use Phpmyadmin is it paossible with vanilla or i have to insall mysql?
also my old site database was installed on Mysql , would it work the same with vanilla mysql?
also how can i create an sql dataabe , username , passwrd using vaniall mysql?
And do i have to unistall vanilla mysql to install mysql
View 2 Replies
View Related
Aug 14, 2008
I have a very good free web hosting company. My one user needs to be able to upload a 16 meg sql file in php. I tried bigphp, but it game me an error that the sql file doesent have a semicolon followed by a linebreak at the end of each query in the file.
I know there is some sort of SSH command i can run to import this sql file to his account. I am using layered panel. So what is the easiest way here?
Also i have 20MB php.ini settings for uploads, post size, etc.
View 5 Replies
View Related
Feb 16, 2008
Im getting an arror in phpmyadmin #2002
phpMyAdmin - Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
and when restarting mysql im getting this error
Attempting to restart mysql Waiting for mysql to restart.... . . . . . . . . . . finished.
mysql status
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
View 3 Replies
View Related
Jun 22, 2008
How can I configure the phpmyadmin in plesk to show databases?
because when my customers trying to access to phpmyadmin show access denied.
View 6 Replies
View Related
Jun 4, 2007
I just upgraded to Debian from RedHat, but I'm a little lost trying to get phpMyAdmin working. Below is a snapshot of my config.
I'm sure I'm missing something.
looks like I have the packages...
debianlinux [/root] # dpkg -l | grep php
ii libapache-mod-php5 5.2.0-8+etch4
ii libapache2-mod-php4 4.4.4-8+etch2
ii php4-common 4.4.4-8+etch2
ii php5-common 5.2.0-8+etch4
ii php5-gd 5.2.0-8+etch4
ii php5-mcrypt 5.2.0-8+etch4
ii php5-mysql 5.2.0-8+etch4
ii phpmyadmin 2.9.1.1-3
am I missing any apache modules?
debianlinux [/etc/apache2] # apache2ctl -t -D DUMP_MODULES
Loaded Modules:
core_module (static)
log_config_module (static)
logio_module (static)
mpm_prefork_module (static)
http_module (static)
so_module (static)
alias_module (shared)
auth_basic_module (shared)
authn_file_module (shared)
authz_default_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
cgi_module (shared)
dir_module (shared)
env_module (shared)
mime_module (shared)
python_module (shared)
negotiation_module (shared)
perl_module (shared)
php4_module (shared)
setenvif_module (shared)
status_module (shared)
Syntax OK
here is my short and sweet apache2.conf
debianlinux [/etc/apache2] # cat apache2.conf
ServerRoot "/etc/apache2/"
ServerName debianlinux
LockFile /var/lock/apache2/accept.lock
PidFile /var/run/apache2.pid
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule mpm_prefork_module>
StartServers 5
MinSpareServers 5
MaxSpareServers 10
MaxClients 150
MaxRequestsPerChild 0
</IfModule>
<IfModule mpm_worker_module>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
User apache2
Group apache2
AccessFileName .htaccess
<Files ~ "^.ht">
Order allow,deny
Deny from all
</Files>
TypesConfig /etc/mime.types
DefaultType text/plain
HostnameLookups Off
ErrorLog /var/log/apache2/error.log
LogLevel warn
Include /etc/apache2/mods-enabled/*.load
Include /etc/apache2/mods-enabled/*.conf
Include /etc/apache2/ports.conf
Include /etc/apache2/conf.d/
LogFormat "%h %l %u %t "%r" %>s %b "%{Referer}i" "%{User-Agent}i"" combined
LogFormat "%h %l %u %t "%r" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
ServerSignature Off
<IfModule alias_module>
Alias /icons/ "/usr/share/apache2/icons/"
<Directory "/usr/share/apache2/icons">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
</IfModule>
<IfModule mod_autoindex.c>
IndexOptions FancyIndexing VersionSort HTMLTable NameWidth=*
DefaultIcon /icons/blank.gif
ReadmeName README.html
HeaderName HEADER.html
IndexIgnore .??* *~ *# RCS CVS *,v *,t
</IfModule>
<IfModule mod_mime.c>
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
</IfModule>
<IfModule mod_mime.c>
AddCharset us-ascii .ascii .us-ascii
AddCharset ISO-8859-1 .iso8859-1 .latin1
AddHandler type-map var
AddType text/html .shtml
AddOutputFilter INCLUDES .shtml
</IfModule>
Include /etc/apache2/sites-enabled/
Include /etc/phpmyadmin/apache.conf
I can hit my default site okay, which in in /root (for testing)
debianlinux [/etc/apache2/sites-available] # cat default
NameVirtualHost *
<VirtualHost *>
ServerAdmin webmaster@localhost
DocumentRoot /root/public_html/
<Directory /root/public_html/>
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory /root/public_html/>
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all
</Directory>
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
<Directory "/usr/lib/cgi-bin">
AllowOverride None
Options ExecCGI -MultiViews +SymLinksIfOwnerMatch
Order allow,deny
Allow from all
</Directory>
ErrorLog /var/log/apache2/error.log
LogLevel warn
CustomLog /var/log/apache2/access.log combined
Alias /doc/ "/usr/share/doc/"
<Directory "/usr/share/doc/">
Options Indexes MultiViews FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
Allow from 127.0.0.0/255.0.0.0 ::1/128
</Directory>
</VirtualHost>
what about phpMyAdmin configuration?
debianlinux [/etc/phpmyadmin] # ls -la
total 44
drwxr-xr-x 2 root root 4096 2007-06-02 06:54 .
drwxr-xr-x 72 root root 4096 2007-06-03 10:59 ..
-rw-r--r-- 1 root root 654 2007-06-02 06:34 apache.conf
-rw-r--r-- 1 root root 205 2007-06-02 06:35 apache.conf.beta
-rw-r----- 1 root www-data 63 2007-05-29 05:39 blowfish_secret.inc.php
-rw-r--r-- 1 root root 170 2007-05-29 05:39 config.footer.inc.php
-rw-r--r-- 1 root root 170 2007-05-29 05:39 config.header.inc.php
-rw-r--r-- 1 root root 5943 2007-05-29 05:39 config.inc.php
-rw-r--r-- 1 root root 1542 2007-06-02 06:35 htaccess
-rw-r----- 1 root www-data 8 2007-05-29 05:39 htpasswd.setup
here is contents of config.inc.php
<?php
$i = 0;
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
?>
all the phpmyadmin files are in /usr/share/phpmyadmin - any config tasks here?
View 8 Replies
View Related
Aug 17, 2007
I allow my clients to access their mysql database through phpmyadmin, however I do not do it through cpanel or anything else like that. I run gameservers that utilize MySQL.
Usually when they login to phpmyadmin a window pops up and asks for login details, however I want to change it into a login page and I am not quite sure how to do so. I want to change it into something like this: [url]
What do I have to do to make a login page like this?
View 1 Replies
View Related
Mar 2, 2007
This should be a routine walk in the park job for me but for some reason this time the phpmyadmin installation on debian is giving me so much trouble. I have installed it numerous times with no issues.
I am trying phpmyadmin installation the usual way, "apt-get install phpmyadmin" but no matter what I do I keep getting "500 Internal Server Error".
My mysql server has a root password.
I know debian well and they wont put a package up which has not been tested well so I am surprised phpmyadmin is not working properly on the basic installation.
I have been trying to make it work for 3 days now and as a last resort I am coming here to see if someone can shed some light on the issue.
View 4 Replies
View Related
Jan 30, 2007
MySQL 5.0.27
phpMyAdmin 2.5.0
Php ver 4.4.0
IIS6 Win2003 Web Edition - dedicated
I cannot work out what is going wrong here. I have been up all night trying to work it out!
Have installed MySQL + PHPmyAdmin no errors no problems. Log into phpmyadmin and look at a database but it will not show how many records are in the field nor what size the records are. It says records - unknown, size unknown
View 4 Replies
View Related
Oct 30, 2007
How do I grant someone access to only ONE mysql database, via phpmyadmin on a cpanel box? What would the login be (format)? A particular domain has 5 mysql databases, so do not want to give the tech regular cpanel access.
View 9 Replies
View Related
