ok great, lets just remind how i started. I will blog where you should refer for each step and after finishing you can come back here to see what next to do. So I thought it would be useful to blog all these steps together for someone to finish this little easily. So I started all this from searching in google like ‘how to install tomcat on mac os’ and then ‘how to install mysql on mac os’ and then ‘how to set environment variables on mac os’ so and so whole day to run my app on tomcat at my MacBook. For other work on development I mostly used my Ubuntu OS at home PC. I have been using Mac OS for more than a year still only used it for mainly iPhone Development work.
Open Terminal and type the following command to invoke the mysql_upgrade package.I wanted to install tomcat, MySQL and then run a jsp application that connects to a MySQL DB on tomcat in Mac OS X.It is highly recommended to take a backup of your MySQL databases before running this command. The steps below are an example to run mysql_upgrade inside a MAMP Pro server environment.
In order to run mysql_upgrade, you need to login to MySQL Server via command line and invoke the package. You have an error in your SQL syntax check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql_upgrade' at line 1 If you are having trouble running the mysql_upgrade package command, it’s likely you aren’t running it correctly. InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. If you have upgraded SQL server from previous versions before and never ran the mysql_upgrade package, chances are your mysql_error.log is filling up with errors below. The mysql_upgrade package ensures your database tables are upgraded and ensures there are no incompatibilities you’re your current version of MariaDB server. If you recently upgraded your MySQL server version, you probably didn’t know that you need to run the mysql_upgrade package on all your databases as well.
0 kommentar(er)
