Can you create views in mysql?

[haggis73]

Hello all,

I am importing a SQL backup in phpmyadmin and getting following issue

/*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`sarsc_sessionweb`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `sessioninfo` AS select `m`.`sessionid` AS `sessionid`,`m`.`versionid` A

#1227 - Access denied; you need the SUPER privilege for this operation

I assume it is failing at the VIEW? I may be wrong.

On the cpanel mysql I can see the user has ability to Create View.

I have came across the following thread - https://community.x10hosting.com/th...ilege-required-to-create-view-in-mysql.74124/ which says you cannot create databases.

Any assistance appreciated...

 

[AngusThermopyle]

You could try:
1. Set DEFINER to just your cPanel username (how phpMyAdmin runs)
OR
2. Remove the DEFINER clause altogether.

 

[haggis73]

I will give those 2 suggestions a try. Cheers/

 

[haggis73]

You could try:
1. Set DEFINER to just your cPanel username (how phpMyAdmin runs)
OR
2. Remove the DEFINER clause altogether.

legend point 1 worked.. I was using the user set up for the database over the cpanel one.