usuaris de mysql i permisos

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select user from user;
+------------------+
| user             |
+------------------+
| sjordi           |
| root             |
| root             |
| debian-sys-maint |
| phpmyadmin       |
| root             |
| santj            |
| root             |
+------------------+
8 rows in set (0.55 sec)



mysql> show grants for sjordi;
+-------------------------------------------------------------------------------------------------------+
| Grants for sjordi@%                                                                                   |
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'sjordi'@'%' IDENTIFIED BY PASSWORD '*xxxxx' |
| GRANT ALL PRIVILEGES ON `concurs-sjordi`.* TO 'sjordi'@'%'                                            |
+-------------------------------------------------------------------------------------------------------+
2 rows in set (0.25 sec)

duplicar una taula mysql, la seva estructura

necessito crear la estructura de la taula sjordi2015 i crear-la pel nou concurs sjordi 2016

mysql> create table sjordi2016 like sjordi2015;
Query OK, 0 rows affected (5.76 sec)

no m'interesa conservar dades anteriors

http://cambrico.net/mysql/duplicar-o-clonar-tablas-en-mysql