Reinstall Wordpress, clear database tables first

If I have Wordpress database 'wpdb', user 'wpuser' together with password 'HAL3jpz4v7xzvGLZ' then I enter databse mode:
mysql -uwpuser -pHAL3jpz4v7xzvGLZ
Execute MySQL commands:
use wpdb;
show tables;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS wp_commentmeta;
DROP TABLE IF EXISTS wp_comments;
DROP TABLE IF EXISTS wp_links;
DROP TABLE IF EXISTS wp_options;
DROP TABLE IF EXISTS wp_postmeta;
DROP TABLE IF EXISTS wp_posts;
DROP TABLE IF EXISTS wp_term_relationships;
DROP TABLE IF EXISTS wp_term_taxonomy;
DROP TABLE IF EXISTS wp_termmeta;
DROP TABLE IF EXISTS wp_terms;
DROP TABLE IF EXISTS wp_usermeta;
DROP TABLE IF EXISTS wp_users;
show tables;
SET FOREIGN_KEY_CHECKS = 1;
exit

No comments: