MySQL データベースの Google Cloud SQL への移行: チャレンジラボ のレビュー

google2623790_student@blog:~$ hostname blog google2623790_student@blog:~$ mysql --user=blogadmin --password=Password1 --host=127.0.0.1 wordpress ERROR 1045 (28000): Access denied for user 'blogadmin'@'localhost' (using password: YES)

Howard Rik · 7年以上前にレビュー済み

Great lab using whatever knowledge you had from linux and mysql for the import and export. The rest was really easy.

Sánchez Luis · 7年以上前にレビュー済み

completed ok

Adedeji Adewade · 7年以上前にレビュー済み

The password for the database in the instructions is incorrect.

Dahlqvist Jimmy · 7年以上前にレビュー済み

Dahlqvist Jimmy · 7年以上前にレビュー済み

MENEZES GODFREY · 7年以上前にレビュー済み

MENEZES GODFREY · 7年以上前にレビュー済み

nice!!!

Pulido Nicolas · 7年以上前にレビュー済み

Poozhikalayil Prasad · 7年以上前にレビュー済み

No good. Very much like a real world example where people don't know (or perhaps regularly lie) about the state a machine is in. An exercise in frustration at not being able to login to the database with the provided credential, nor use the google-recommended low-downtime procedures. First the blogadmin mysql password is not as described. And --set-gtid-purged=on is not supported by the maria version being used, which is a recommended setting from google when using mysqldump. Without the proper password, of course, you can still start mysql in safe mode.... and after looking around -- the blogadmin user exists but is restricted to localhost so how will the cloud sql migration agent attach to become a slave replica? Not a good way to show off how easy it would be to migrate to cloud sql.

Brewer Paul · 7年以上前にレビュー済み

Coloma García Norman · 7年以上前にレビュー済み

Shibanov Pavel · 7年以上前にレビュー済み

Klimus Marcin · 7年以上前にレビュー済み

Two things to be noted. 1. Password for local mysql instance is Password1*. 2. Add /32 to your static IP to whitelist the instance in CloudSQL.

Nagarajan Sakthi Pravin · 7年以上前にレビュー済み

why does the config update do not work and allow the wp site to establish db connectivity? there seems to be no logical explanation of why this does not work when you specify all the appropriate ip details on both cloudsql side as well as within wp-config.php, i can connect to cloudsql db using mysql command line yet wordpress does not connect? why?

Desai Mayank · 7年以上前にレビュー済み

why does the config update do not work and allow the wp site to establish db connectivity? there seems to be no logical explanation of why this does not work when you specify all the appropriate ip details on both cloudsql side as well as within wp-config.php, i can connect to cloudsql db using mysql command line yet wordpress does not connect? why?

Desai Mayank · 7年以上前にレビュー済み

Chandrashekhar Pradeep · 7年以上前にレビュー済み

Though the blog instance connects to Cloud SQL ( have added the blog static ip in sql authorized network ip ) , the scoring UI doesn't seem to check correctly that the blog instance accesses SQL. This can also be seen here from the mysql command -> google2582317_student@blog:~$ mysql -u blogadmin -p -h 35.184.134.60 -D wordpress Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 430 Server version: 5.7.14-google-log (Google) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [wordpress]>

Chandrashekhar Pradeep · 7年以上前にレビュー済み

The password mentioned in the instructions should be Password1* instead of Password1 - found this from instance startup script & wp-config.php. Though the blog instance could connect to sql instance , the score gui could not check that fine.

Chandrashekhar Pradeep · 7年以上前にレビュー済み

The password mentioned in the instructions should be Password1* instead of Password1 - found this from instance startup script & wp-config.php. Though the blog instance could connect to sql instance , the score gui could not check that fine.

Chandrashekhar Pradeep · 7年以上前にレビュー済み

C Telmo · 7年以上前にレビュー済み

lkfhaspijdakfjsda

Pavlovic Robert · 7年以上前にレビュー済み

Incorrect Password. Could not connect to Mysql

Nagarajan Sakthi Pravin · 7年以上前にレビュー済み

Incorrect Password. Could not connect to Mysql

Nagarajan Sakthi Pravin · 7年以上前にレビュー済み

Kalani Amit · 7年以上前にレビュー済み