Sfrgttk

Why does Python copy numpy arrays where the length of the dimensions are the same?

If an area is covered in both Ball Bearings and Caltrops, does the creature need to move at half speed or quarter speed to avoid both their effects?

GPL - Is it required to post source code to the Public - when is a software released?

Is Screenshot Time-tracking Common?

Why is Shelob considered evil?

Suggestions on how to improve logo

Is the "hot network questions" element on Stack Overflow a dark pattern?

Why does finding small effects in large studies indicate publication bias?

Does limiting the number of sources help simplify the game for a new DM with new and experienced players?

What is the Guild Die for?

What happens if you declare more than $10,000 at the US border?

Why are recumbent bicycles and velomobiles illegal in UCI bicycle racing?

Negotiating 1-year delay to my Assistant Professor Offer

Is it possible to detect 100% of SQLi with a simple regex?

How to not forget my phone in the bathroom?

How to know if I am a 'Real Developer'

Apparently I’m calling random numbers but there's nothing in the call log

Why is it a problem for Freddie if the guys from Munich did what he wanted?

Does the phrase がんばする makes sense?

Complicated square root problem.

Workplace intimidation due to child's chronic health condition

Does an increasing sequence of reals converge if the difference of consecutive terms approaches zero?

Why do most space probes survive for far longer than they were designed for?

Why would you use 2 alternate layout buttons instead of 1, when only one can be selected at once

Cannot change collation on my MySQL database for all tables - please help

Setting default charset/collation for MySQL databaseHelp configuring MySQL install for remote connections / root accounts understandingopen mysql on os x backup disk imageMove databases on same MacHow can I change collation for all tables and columns in MySQL database?can't create schema for mysql databaseMySQL - Slow InnoDB Write Speeds on Windows 10Migrate SQL Server backup to MySQL for a Wordpress siteStarting MySql Failed: check log for more infoCannot restore MySQL database from .frm and .ibd files

0

I have MAMP installed on my Macbook, I open up phpMyAdmin and go to Operations, I choose the Collation that I need to use for my WordPress site. I then click "GO", but when I run the following query it still shows the old Collation, not the new one I need.

Is there some MySQL query I can run that will change the collation for me on all my tables?

mysql mac-os-x

share|improve this question

edited Apr 25 '17 at 6:24

Marco

3,73231624

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

I have MAMP installed on my Macbook, I open up phpMyAdmin and go to Operations, I choose the Collation that I need to use for my WordPress site. I then click "GO", but when I run the following query it still shows the old Collation, not the new one I need.

Is there some MySQL query I can run that will change the collation for me on all my tables?

mysql mac-os-x

share|improve this question

edited Apr 25 '17 at 6:24

Marco

3,73231624

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I have MAMP installed on my Macbook, I open up phpMyAdmin and go to Operations, I choose the Collation that I need to use for my WordPress site. I then click "GO", but when I run the following query it still shows the old Collation, not the new one I need.

Is there some MySQL query I can run that will change the collation for me on all my tables?

mysql mac-os-x

share|improve this question

edited Apr 25 '17 at 6:24

Marco

3,73231624

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

share|improve this question

edited Apr 25 '17 at 6:24

Marco

3,73231624

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

share|improve this question

edited Apr 25 '17 at 6:24

Marco

3,73231624

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

edited Apr 25 '17 at 6:24

Marco

3,73231624

edited Apr 25 '17 at 6:24

Marco

3,73231624

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

asked Apr 24 '17 at 22:03

I Am Sir Ask AlotI Am Sir Ask Alot

11

1 Answer
1

active

oldest

votes

0

I found the answer.

If you run the following SQL query, it will produce a list of ALTER TABLE statements that you can then paste in the "Run SQL Query" in phpMyAdmin:

SELECT ('ALTER TABLE `', tbl.`TABLE_SCHEMA`, '`.`', tbl.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM `information_schema`.`TABLES` tbl WHERE tbl.`TABLE_SCHEMA` = 'dbase'

The list will then produce as many ALTER TABLE statements as there are tables that you have.

So for instance, it will produce something like this:

ALTER TABLE `dbname`.`tablename` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Then, you just copy/past that ALTER TABLE in the Run SQL Query windows and run it.

share|improve this answer

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});


}
});

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f171875%2fcannot-change-collation-on-my-mysql-database-for-all-tables-please-help%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

I found the answer.

If you run the following SQL query, it will produce a list of ALTER TABLE statements that you can then paste in the "Run SQL Query" in phpMyAdmin:

SELECT ('ALTER TABLE `', tbl.`TABLE_SCHEMA`, '`.`', tbl.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM `information_schema`.`TABLES` tbl WHERE tbl.`TABLE_SCHEMA` = 'dbase'

The list will then produce as many ALTER TABLE statements as there are tables that you have.

So for instance, it will produce something like this:

ALTER TABLE `dbname`.`tablename` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Then, you just copy/past that ALTER TABLE in the Run SQL Query windows and run it.

share|improve this answer

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11

add a comment | 

0

I found the answer.

If you run the following SQL query, it will produce a list of ALTER TABLE statements that you can then paste in the "Run SQL Query" in phpMyAdmin:

SELECT ('ALTER TABLE `', tbl.`TABLE_SCHEMA`, '`.`', tbl.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM `information_schema`.`TABLES` tbl WHERE tbl.`TABLE_SCHEMA` = 'dbase'

The list will then produce as many ALTER TABLE statements as there are tables that you have.

So for instance, it will produce something like this:

ALTER TABLE `dbname`.`tablename` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Then, you just copy/past that ALTER TABLE in the Run SQL Query windows and run it.

share|improve this answer

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11

add a comment | 

I found the answer.

If you run the following SQL query, it will produce a list of ALTER TABLE statements that you can then paste in the "Run SQL Query" in phpMyAdmin:

SELECT ('ALTER TABLE `', tbl.`TABLE_SCHEMA`, '`.`', tbl.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM `information_schema`.`TABLES` tbl WHERE tbl.`TABLE_SCHEMA` = 'dbase'

The list will then produce as many ALTER TABLE statements as there are tables that you have.

So for instance, it will produce something like this:

ALTER TABLE `dbname`.`tablename` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Then, you just copy/past that ALTER TABLE in the Run SQL Query windows and run it.

share|improve this answer

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11

SELECT ('ALTER TABLE `', tbl.`TABLE_SCHEMA`, '`.`', tbl.`TABLE_NAME`, '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') FROM `information_schema`.`TABLES` tbl WHERE tbl.`TABLE_SCHEMA` = 'dbase'

ALTER TABLE `dbname`.`tablename` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

share|improve this answer

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11

answered Apr 24 '17 at 23:34

I Am Sir Ask AlotI Am Sir Ask Alot

11