The PHPMYADMIN login error “Login without a password is forbidden by configuration (see AllowNoPassword)”. This is happening because of the phpMyAdmin default configuration. PHPMyAdmin is a tool for manage MySQL in Web. It has a login interface to create and modify databases. Most people run phpMyAdmin without password for local development to avoid the time…
Category: SQL
SQL – find records from one table which don’t exist in another
company_services +—-+——+————–+ | id | name | company_id| +—-+——+————–+ | 1 | IT services| 102| +—-+——+————–+ | 2 | hardware| 105| +—-+——+————–+ company_products +—-+——+————–+ | id | title| company_id | +—-+——+————–+ | 1 | Mouse| 101| +—-+——+————–+ +—-+——+————–+ | 2 | Keyboard| 102| +—-+——+————–+ SELECT count(*)FROM company_services WHERE company_id NOT IN (SELECT company_id FROM company_products)…
Resetting forgotten phpmyadmin password
Simply change or reset your MySQL root password by doing the following: Run the following commands in Terminal Step 1 :Stop the MySQL server sudo service mysql stop Step 2 : Start mysqld sudo mysqld –skip-grant-tables $; Step 3:Login to MySQL as root mysql -u root mysql Step 4 :Change MYSECRET with your new root…
Change db collation of all tables in mysql
SELECT CONCAT( ‘ALTER TABLE `’, t.`TABLE_SCHEMA` , ‘`.`’, t.`TABLE_NAME` , ‘` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;’ ) AS stmt FROM `information_schema`.`TABLES` t WHERE 1 AND t.`TABLE_SCHEMA` = ” ORDER BY 1 LIMIT 0 , 50 Above mysql query generate Alter table commands for the specified database. Run these sql statement as group.
How can be list the installed SQL Server instances
Press window+R windows run window will open and then type cmd Command prompt will open Run the following command OSQL -L in in command prompt. It will list the server instance names. Example C:Userssmarttips>OSQL -L Servers: (local) smarttipsserver Free Download of the Microsoft sqlserver 2012 from following link: http://188.138.9.141/Getintopc.com/SQLEXPRWT_x64_ENU.exe