PHPmyAdmin Default DatabasesIs it okay to delete the standard pre-made databases in phpMyAdmin?Bad Situation importing/exporting img files - mysql databaseError Dropping Database (Can't rmdir '.test', errno: 17)Deleting mysql entries with phpmyadmin leaves behind blank entriescant connect to the correct localhost/phpmyadminConnecting my MySQL databases to phpMyAdminMySQL database shows in phpMyAdmin but not the command line clientPhpMyAdmin and Mysql databasesValet - phpMyAdmin throws 404 not foundMysql database repairubuntu 16.04 install phpmyadmin 404
How does a program know if stdout is connected to a terminal or a pipe?
How to denote matrix elements succinctly?
Why did C use the -> operator instead of reusing the . operator?
A Paper Record is What I Hamper
What are the characteristics of a typeless programming language?
How do I deal with a coworker that keeps asking to make small superficial changes to a report, and it is seriously triggering my anxiety?
Pre-plastic human skin alternative
A strange hotel
"You've called the wrong number" or "You called the wrong number"
Why was the Spitfire's elliptical wing almost uncopied by other aircraft of World War 2?
555 timer FM transmitter
Does Gita support doctrine of eternal samsara?
Is this homebrew Wind Wave spell balanced?
Do I have an "anti-research" personality?
Was there a Viking Exchange as well as a Columbian one?
Why do games have consumables?
What's the name of these pliers?
How much cash can I safely carry into the USA and avoid civil forfeiture?
Re-entry to Germany after vacation using blue card
a sore throat vs a strep throat vs strep throat
How to fry ground beef so it is well-browned
What's the polite way to say "I need to urinate"?
If a planet has 3 moons, is it possible to have triple Full/New Moons at once?
Is it idiomatic to construct against `this`
PHPmyAdmin Default Databases
Is it okay to delete the standard pre-made databases in phpMyAdmin?Bad Situation importing/exporting img files - mysql databaseError Dropping Database (Can't rmdir '.test', errno: 17)Deleting mysql entries with phpmyadmin leaves behind blank entriescant connect to the correct localhost/phpmyadminConnecting my MySQL databases to phpMyAdminMySQL database shows in phpMyAdmin but not the command line clientPhpMyAdmin and Mysql databasesValet - phpMyAdmin throws 404 not foundMysql database repairubuntu 16.04 install phpmyadmin 404
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Ok this is more of a 'Keeping my house in order' question.
PHPmyAdmin is installed but it has a bunch of databases installed as default.
•cdcol (1)
•information_schema (37)
•mysql (24)
•performance_schema (17)
•phpmyadmin (8)
•test
•webauth (1)
I recently deleted a bunch of these but after that I had lots of issues accessing PHPmyAdmin and had to re-install. Anyway long story short can I happily delete these without effecting my system?
phpmyadmin
add a comment |
Ok this is more of a 'Keeping my house in order' question.
PHPmyAdmin is installed but it has a bunch of databases installed as default.
•cdcol (1)
•information_schema (37)
•mysql (24)
•performance_schema (17)
•phpmyadmin (8)
•test
•webauth (1)
I recently deleted a bunch of these but after that I had lots of issues accessing PHPmyAdmin and had to re-install. Anyway long story short can I happily delete these without effecting my system?
phpmyadmin
2
Considering these tables contain things like user accounts and information about your databases, I'd say no. You might want to look up what these things do before deleting them.
– monkeymatrix
Jan 28 '13 at 13:51
add a comment |
Ok this is more of a 'Keeping my house in order' question.
PHPmyAdmin is installed but it has a bunch of databases installed as default.
•cdcol (1)
•information_schema (37)
•mysql (24)
•performance_schema (17)
•phpmyadmin (8)
•test
•webauth (1)
I recently deleted a bunch of these but after that I had lots of issues accessing PHPmyAdmin and had to re-install. Anyway long story short can I happily delete these without effecting my system?
phpmyadmin
Ok this is more of a 'Keeping my house in order' question.
PHPmyAdmin is installed but it has a bunch of databases installed as default.
•cdcol (1)
•information_schema (37)
•mysql (24)
•performance_schema (17)
•phpmyadmin (8)
•test
•webauth (1)
I recently deleted a bunch of these but after that I had lots of issues accessing PHPmyAdmin and had to re-install. Anyway long story short can I happily delete these without effecting my system?
phpmyadmin
phpmyadmin
edited Jan 28 '13 at 13:47
BrogenMacy
asked Jan 28 '13 at 13:41
BrogenMacyBrogenMacy
1052310
1052310
2
Considering these tables contain things like user accounts and information about your databases, I'd say no. You might want to look up what these things do before deleting them.
– monkeymatrix
Jan 28 '13 at 13:51
add a comment |
2
Considering these tables contain things like user accounts and information about your databases, I'd say no. You might want to look up what these things do before deleting them.
– monkeymatrix
Jan 28 '13 at 13:51
2
2
Considering these tables contain things like user accounts and information about your databases, I'd say no. You might want to look up what these things do before deleting them.
– monkeymatrix
Jan 28 '13 at 13:51
Considering these tables contain things like user accounts and information about your databases, I'd say no. You might want to look up what these things do before deleting them.
– monkeymatrix
Jan 28 '13 at 13:51
add a comment |
2 Answers
2
active
oldest
votes
Not all of those listed databases are phpMyAdmin
related. Some are required for MySQL to operate normally.
performance_schema
http://dev.mysql.com/doc/refman/5.5/en/performance-schema.htmlinformation_schema
http://dev.mysql.com/doc/refman/5.5/en/information-schema.htmltest
http://dev.mysql.com/doc/refman/5.0/en/database-use.htmlmysql
http://dev.mysql.com/doc/refman/5.5/en//adding-users.html
cdcol
Probably is for the cd collection sample database that comes with XAMPP
. webauth
is probably part of XAMPP
as well.
The only phpMyAdmin
related database (as you probably already guessed) is phpmyadmin
, you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin
.
add a comment |
Delete the cdcol database; it is just a sample. For the other tables you mentioned, hide them from view by adding the following to config.inc.php.
$cfg['Servers'][$i]['hide_db']='^(information_schema|performance_schema|mysql|phpmyadmin|test|webauth)$';
3
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
8
Very nice, alternatively you can set it in phpMyAdmin itself atSettings > Features > General > Hide databases
and enter your value with regular expression.
– vonUbisch
Sep 3 '15 at 8:44
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f14563328%2fphpmyadmin-default-databases%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Not all of those listed databases are phpMyAdmin
related. Some are required for MySQL to operate normally.
performance_schema
http://dev.mysql.com/doc/refman/5.5/en/performance-schema.htmlinformation_schema
http://dev.mysql.com/doc/refman/5.5/en/information-schema.htmltest
http://dev.mysql.com/doc/refman/5.0/en/database-use.htmlmysql
http://dev.mysql.com/doc/refman/5.5/en//adding-users.html
cdcol
Probably is for the cd collection sample database that comes with XAMPP
. webauth
is probably part of XAMPP
as well.
The only phpMyAdmin
related database (as you probably already guessed) is phpmyadmin
, you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin
.
add a comment |
Not all of those listed databases are phpMyAdmin
related. Some are required for MySQL to operate normally.
performance_schema
http://dev.mysql.com/doc/refman/5.5/en/performance-schema.htmlinformation_schema
http://dev.mysql.com/doc/refman/5.5/en/information-schema.htmltest
http://dev.mysql.com/doc/refman/5.0/en/database-use.htmlmysql
http://dev.mysql.com/doc/refman/5.5/en//adding-users.html
cdcol
Probably is for the cd collection sample database that comes with XAMPP
. webauth
is probably part of XAMPP
as well.
The only phpMyAdmin
related database (as you probably already guessed) is phpmyadmin
, you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin
.
add a comment |
Not all of those listed databases are phpMyAdmin
related. Some are required for MySQL to operate normally.
performance_schema
http://dev.mysql.com/doc/refman/5.5/en/performance-schema.htmlinformation_schema
http://dev.mysql.com/doc/refman/5.5/en/information-schema.htmltest
http://dev.mysql.com/doc/refman/5.0/en/database-use.htmlmysql
http://dev.mysql.com/doc/refman/5.5/en//adding-users.html
cdcol
Probably is for the cd collection sample database that comes with XAMPP
. webauth
is probably part of XAMPP
as well.
The only phpMyAdmin
related database (as you probably already guessed) is phpmyadmin
, you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin
.
Not all of those listed databases are phpMyAdmin
related. Some are required for MySQL to operate normally.
performance_schema
http://dev.mysql.com/doc/refman/5.5/en/performance-schema.htmlinformation_schema
http://dev.mysql.com/doc/refman/5.5/en/information-schema.htmltest
http://dev.mysql.com/doc/refman/5.0/en/database-use.htmlmysql
http://dev.mysql.com/doc/refman/5.5/en//adding-users.html
cdcol
Probably is for the cd collection sample database that comes with XAMPP
. webauth
is probably part of XAMPP
as well.
The only phpMyAdmin
related database (as you probably already guessed) is phpmyadmin
, you can delete it, but letting it be there would improve performance, and add more functionality to the phpMyAdmin
.
answered Jan 28 '13 at 14:00
racetrackracetrack
3,3212629
3,3212629
add a comment |
add a comment |
Delete the cdcol database; it is just a sample. For the other tables you mentioned, hide them from view by adding the following to config.inc.php.
$cfg['Servers'][$i]['hide_db']='^(information_schema|performance_schema|mysql|phpmyadmin|test|webauth)$';
3
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
8
Very nice, alternatively you can set it in phpMyAdmin itself atSettings > Features > General > Hide databases
and enter your value with regular expression.
– vonUbisch
Sep 3 '15 at 8:44
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
add a comment |
Delete the cdcol database; it is just a sample. For the other tables you mentioned, hide them from view by adding the following to config.inc.php.
$cfg['Servers'][$i]['hide_db']='^(information_schema|performance_schema|mysql|phpmyadmin|test|webauth)$';
3
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
8
Very nice, alternatively you can set it in phpMyAdmin itself atSettings > Features > General > Hide databases
and enter your value with regular expression.
– vonUbisch
Sep 3 '15 at 8:44
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
add a comment |
Delete the cdcol database; it is just a sample. For the other tables you mentioned, hide them from view by adding the following to config.inc.php.
$cfg['Servers'][$i]['hide_db']='^(information_schema|performance_schema|mysql|phpmyadmin|test|webauth)$';
Delete the cdcol database; it is just a sample. For the other tables you mentioned, hide them from view by adding the following to config.inc.php.
$cfg['Servers'][$i]['hide_db']='^(information_schema|performance_schema|mysql|phpmyadmin|test|webauth)$';
answered Jan 20 '14 at 21:25
WCJWCJ
20122
20122
3
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
8
Very nice, alternatively you can set it in phpMyAdmin itself atSettings > Features > General > Hide databases
and enter your value with regular expression.
– vonUbisch
Sep 3 '15 at 8:44
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
add a comment |
3
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
8
Very nice, alternatively you can set it in phpMyAdmin itself atSettings > Features > General > Hide databases
and enter your value with regular expression.
– vonUbisch
Sep 3 '15 at 8:44
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
3
3
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
This is exctly the config I was looking for! +1
– Afonso Gomes
Jun 19 '15 at 9:13
8
8
Very nice, alternatively you can set it in phpMyAdmin itself at
Settings > Features > General > Hide databases
and enter your value with regular expression.– vonUbisch
Sep 3 '15 at 8:44
Very nice, alternatively you can set it in phpMyAdmin itself at
Settings > Features > General > Hide databases
and enter your value with regular expression.– vonUbisch
Sep 3 '15 at 8:44
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
very nice solution, exactly what i was looking for! +1
– Kashif Latif
Jan 2 '18 at 10:14
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f14563328%2fphpmyadmin-default-databases%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Considering these tables contain things like user accounts and information about your databases, I'd say no. You might want to look up what these things do before deleting them.
– monkeymatrix
Jan 28 '13 at 13:51