Re: Restauration de base - User not found in user tbl
Bon ben je suis pas bien doué sur cette affaire!
J'ai tapé :
SET @p_login = 'admforum';
SELECT
CONCAT(
'''',
`User`,
'''@''',
`Host`,
''''
)
INTO @login
FROM mysql.user
WHERE `User` = 'root';
SELECT *
FROM information_schema.USER_PRIVILEGES
WHERE GRANTEE = @login;
Et j'ai eu droit à un très flashy :
Requête SQL:
SELECT CONCAT( '''', `User` , '''@''', `Host` , '''' )
INTO @login
FROM mysql.user
WHERE `User` = 'root';
MySQL a répondu:
#1172 - Result consisted of more than one row
Il y a un truc que j'ai pas compris?
Subject
Views
Written By
Posted
4892
December 03, 2013 06:35PM
1608
December 04, 2013 01:35AM
1582
December 04, 2013 03:11AM
1508
December 04, 2013 03:16AM
2312
December 04, 2013 09:01AM
1565
December 04, 2013 09:16AM
1805
December 04, 2013 10:04AM
1835
December 04, 2013 10:24AM
1652
December 04, 2013 10:39AM
1460
December 04, 2013 10:44AM
Re: Restauration de base - User not found in user tbl
1766
December 04, 2013 11:03AM
1568
December 04, 2013 11:10AM
1425
December 04, 2013 01:02PM
1572
December 04, 2013 01:16PM
1644
December 05, 2013 04:43PM
1766
December 05, 2013 05:01PM
1554
December 06, 2013 03:22PM
1653
December 06, 2013 05:55PM