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
I need to put up a VMWare ESX-i server for a short term (less than 6 months) web app development project, and carve out a few virtual servers. This is non-production, so I don't want to tie up one of our $3000 HP rackmounts. Instead the plan is to build a low budget Core 2 Quad, which we can then repurpose as a workstation once the project is done. I have a chassis, disks, etc. in our parts bin at the colo. All I need is the motherboard and SATA RAID controller.
I've heard you need to be careful on hardware selection to be compatable with VMWare ESX/ESXi, otherwise the hypervisor might not install properly (or run stable).
Question: Can anyone offer suggestions on motherboards they've used successfully for VMWare ESX or ESXi version 3? Please, no "it should work" speculation. I'm looking for actual "we used this, and it installed and ran solid" recommendations.
I've looked at the Gigabyte "Ultra Durable II" desktop boards which have served me well. I've also looked at the entry level SuperMicro server boards. Since this is going to be a desktop in a few months, I'd prefer a desktop board-- BUT if VMWare won't like it, I'll spend the extra $150 for a true server board.
The board has to support a minimum of 8 GB RAM, 16 GB or higher would be nice but not mandatory, and MUST support the new 45nm Core2 Quad or Xeon Quad processors.
For storage I'm going to run 4 disks in RAID 10 (1+0) so I need an SATA RAID adapter that is known-compatible with VMWare ESX/ESXi.
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
I am using Windows XP (my laptop) to run a server for localized testing for a site that I run. I am using the WAMP5 on Windows XP.
I got everything setup (phpbb board) vanilla install. Everything went fine, no problems. The script uploaded all the tables on its own.
I pulled the database from the real server to drop into the test site.
Every time I try to upload a sql file that's 11.9Mb in size, I get a "Error: You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit." so I checked the configuration and set it to a 1024Mb file size and like 2048 memory size.
I even tried a 30Kb sized file and I still get the same error. What do I need to do to get this to work?
Also when I check all tables and use the drop down menu to select drop, it just bring my back to the start phpmyadmin page and nothing happens. I can drop the table individually, but that'll take too long, there are over 40 of them.
What else do I need to look for/configure so this will work?
It seems I am having issues with WHM/CPanel. I cannot connect to mysql via phpmyadmin through WHM as a root and get this error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
All users get the same error when they try to access mysql from cpanel. The access seems to be only for valid for 192.168.1.%
Would allowing access to localhost will help and how can I do that for all users?
I currently am running on a VPS and I'm trying to edit the max size a user can upload through phpMyAdmin. I have tried editing the php.ini file located at /etc/php.ini to find it wasn't the right file.
Where do I need to go via SSH to edit the proper file?
One of my users is unable to connect to his database using phpMyAdmin. The query is:
LOAD DATA INFILE '/tmp/phpYXZFfZ' INTO TABLE `count` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY '
And mysql reports:
#1045 - Access denied for user '<USERNAME>'@'%' (using password: YES)
The funny part is that I can connect without any problems from a shell like this:
mysql -u <USERNAME> -p<PASSWORD> -D <DATABASE_NAME>.
This server has been recently migrated from plesk9 to plesk11.5, running on a centos6 OS.
The most important requirement is that the webhost must be fast. It must have alot of bandwidth.
The disc space is not so important. 200 MB would be enough.
It must have PHP, MySQL and phpmyadmin installed.
Must be accesable through FTP.
There are offcourse more requirements. But the main thing is that i want it to be fast.
My pages will be only informative and exists of just mainly text and an image every now and then.
Do you know any fast webhosts that is good to handle websites with large amounts of visitors?
I'm looking for something around 6 dollars per month.
I dont know much about webhosting at all, so i'd appreciate any help i can get
Also i see websites where you can register a domain. But the prices vary, isn't a domain just a domain? What makes this price difference?
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 RelatedI'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.
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
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.
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?
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.
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 Relatedi 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 Relatedi m using DA server. i want to upgrade to latest version.
View 7 Replies View RelatedMy 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.
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.
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
Has anyone seen any docs on upgrading phpMyAdmin? And does it need to be done via SSH?
I'm on a MediaTemple (gs)...
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'] =?
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 RelatedBecause 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.
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 ...
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?
how can install mbstring for phpmyadmin in lxadmin?
View 3 Replies View RelatedI 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.
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.
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").