Web Hosting Technology Blog by JodoHost

Tag overview for: 'sql'

Entries on this site with 'sql'

• SQL query to set/update the MySQL user password in the old style
  The following query can be used to set/update the MySQL user password in the old style:- SET PASSWORD FOR 'user'@'%'=OLD_PASSWORD('password'); FLUSH Privileges;
• Steps to restart the MSSQL server services
  You can re-start the SQL server in 3 ways: 1. Management Studio - Open the Management Studio, connect to the server, right-click on the server name and click restart. 2. S
• How to take a MySQL database schema backup using the command line
  The following command can be used to take a MySQL database schema backup on the command line :- command : mysqldump -u dbusername -p passwd datbase_name --no-data=true >>
• How to change PostgreSQL database encoding
  To accomplish this task, we need to delete the existing database first and then re-create the same with the required encoding. Steps:- ? 1. Login to the respective Postgre
• How to move your database onto a new server
  1) First take backups of the databases which are in your account. 2) Remove the databases one by one and then disable the MSSQL resource and then again "enable" it. This w
• Backup or Restore your Mysql Database using phpMyAdmin
  Taking a Backup or Export of your MySQL database using phpMyAdmin :- -------------------------------------------------------------------------------------------------- Ste
• Block listing of databases for users without access.
  All SQL logins are members of the 'public' server-level role, which by default has the VIEW ANY DATABASE permission. This will revoke that permission : REVOKE VIEW ANY DAT
• How to create the special SQL view for a MSSQL database
  Steps to create the special SQL view for the MSSQL database: 1)? Login to the SQL Server for the database for which the SQL view is to be created. 2)? Open the SQL Server

Related tags

access, backup, collation, database, databases, encoding, export, file, hosting, import, linux, microsoft, msc, mssql, mysql, old, password, permission, pgsql, phpmyadmin, query, restart, restore, server, services, set, style, update

Flickr images for 'sql'