I need to uninstall one of the modules.
I need to drop the column from the database
How can I run this command via ssh to remove it?
I tried on this way not working with me.
1- sudo mysql -u root -p
2- DELETE FROM setup_module WHERE module='_'
Run the below commands:
1) mysql -h localhost -u root 2) use magento23 3) ALTER TABLE admin_user DROP COLUMN created;
localhost = host name
root = user
magento23 = database
admin_user = table name
created = column name which you want to delete
After second step, you can run your required query on the selected database.
1- mysql -u root -p 2 - use database_name 3 - DELETE FROM `setup_module` WHERE `setup_module`.`module` = 'module_name';
Run the following command to connect with the database
mysql -u USERNAME -h HOSTNAMEORIP DATABASENAME -p
Where USERNAME should be your DB Username (Like- root)
Where HOSTNAMEORIP should be your DB Hostname Or IP (Like- localhost)
Where DATABASENAME should be your DB DatabaseName
After filling the details when you click on enter button then you need to fill the Database Password, after filling the password and click on enter button then you will be successfully connected with your database.
To Delete the Column name from the database table
If you are using the MYSQL server then follow the below query to DROP the Column from Database
ALTER TABLE `table_name` DROP `column_name`;
If you are using the SQL server then follow the below query to DROP the column from the Database
ALTER TABLE `table_name` DROP COLUMN `column_name`;