SQL Issues

[kobuvavo]

1. While I went to my "PhpMyadmin", a weird SQL error is persisting me and I haven't written a single line, this issue started after I clicked the SQL tab and the Edit takes me to empty character in the SQL tab and I get different SQL errors in different tabs.

Example in SQL tab:
SELECT `CHARACTER_SET_NAME` AS `Charset`, `DESCRIPTION` AS `Description` FROM `information_schema`.`CHARACTER_SETS`

1143 - SELECT command denied to user 'mysql.infoschema'@'localhost' for column 'default_collation_id' in table 'character_sets'
and edit points to the empty space as not a single SQL command is written

I have below the dash board various other errors, please can you help me to quickly sort out these so that I can learn SQL better.

[Muhammad Zubair]

i am having an issue as i have pre installed MYSQL and now on installing xampp i have following error . do i have to configure different ports for sql one for mysql workbench and other for xampp and if yes how should i?
Initializing Control Panel
4:16:48 PM [main] Windows Version: Home 64-bit
4:16:48 PM [main] XAMPP Version: 7.3.10
4:16:48 PM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
4:16:48 PM [main] You are not running with administrator rights! This will work for
4:16:48 PM [main] most application stuff but whenever you do something with services
4:16:48 PM [main] there will be a security dialogue or things will break! So think
4:16:48 PM [main] about running this application with administrator rights!
4:16:48 PM [main] XAMPP Installation Directory: "d:\new folder\"
4:16:48 PM [main] WARNING: Your install directory contains spaces. This may break programs/scripts
4:16:48 PM [main] Checking for prerequisites
4:16:49 PM [main] All prerequisites found
4:16:49 PM [main] Initializing Modules
4:16:49 PM [mysql] Problem detected!
4:16:49 PM [mysql] Port 3306 in use by "Unable to open process"!
4:16:49 PM [mysql] MySQL WILL NOT start without the configured ports free!
4:16:49 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
4:16:49 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
4:16:49 PM [Tomcat] Problem detected!
4:16:49 PM [Tomcat] Port 8080 in use by ""C:\Program Files (x86)\National Instruments\Shared\NI WebServer\ApplicationWebServer.exe" -user"!
4:16:49 PM [Tomcat] Tomcat WILL NOT start without the configured ports free!
4:16:49 PM [Tomcat] You need to uninstall/disable/reconfigure the blocking application
4:16:49 PM [Tomcat] or reconfigure Tomcat and the Control Panel to listen on a different port
4:16:49 PM [main] Starting Check-Timer
4:16:49 PM [main] Control Panel Ready
4:16:56 PM [Apache] Attempting to start Apache app...
4:16:56 PM [Apache] Status change detected: running
4:17:21 PM [mysql] Problem detected!
4:17:21 PM [mysql] Port 3306 in use by "Unable to open process"!
4:17:21 PM [mysql] MySQL WILL NOT start without the configured ports free!
4:17:21 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
4:17:21 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
4:17:21 PM [mysql] Attempting to start MySQL app...
4:17:21 PM [mysql] Status change detected: running
4:17:23 PM [mysql] Status change detected: stopped
4:17:23 PM [mysql] Error: MySQL shutdown unexpectedly.
4:17:23 PM [mysql] This may be due to a blocked port, missing dependencies,
4:17:23 PM [mysql] improper privileges, a crash, or a shutdown by another method.
4:17:23 PM [mysql] Press the Logs button to view error logs and check
4:17:23 PM [mysql] the Windows Event Viewer for more clues
4:17:23 PM [mysql] If you need more help, copy and post this
4:17:23 PM [mysql] entire log window on the forums
4:22:45 PM [mysql] Problem detected!
4:22:45 PM [mysql] Port 3306 in use by "Unable to open process"!
4:22:45 PM [mysql] MySQL WILL NOT start without the configured ports free!
4:22:45 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
4:22:45 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
4:22:45 PM [mysql] Attempting to start MySQL app...
4:22:45 PM [mysql] Status change detected: running
4:22:47 PM [mysql] Status change detected: stopped
4:22:47 PM [mysql] Error: MySQL shutdown unexpectedly.
4:22:47 PM [mysql] This may be due to a blocked port, missing dependencies,
4:22:47 PM [mysql] improper privileges, a crash, or a shutdown by another method.
4:22:47 PM [mysql] Press the Logs button to view error logs and check
4:22:47 PM [mysql] the Windows Event Viewer for more clues
4:22:47 PM [mysql] If you need more help, copy and post this
4:22:47 PM [mysql] entire log window on the forums