Access Denied for user @localhost

Next topic

Author	Message
Commando Rambo	Monday 19 January 2004 6:38:48 pm Have just reinstalled ezPublish 3.2 as i made a mistake in the tutorial provided. Installation completed by ignoring a couple of errors which came up about not being able to edit some dlls. Install completed, but when I try to log into the admin_page with the username admin and pwd publish it doesn't recognise it. I then went into mysql and asked it to show me the databases and tables i had. when i tried to access the table plain, it says "access denied for user @localhost. Any idea's on why this is happening? NOTE: was working the first time I installed, but error started appearing after an uninstall and reinstall.
James Packham	Tuesday 20 January 2004 1:57:26 am The "user @localhost" bit suggests you didn't enter a username when you ran mysql. You want to enter something like: mysql -u root -p This will prompt you for your database password. Once you're in you should be able to show your databases etc. Next seeing as its a fresh install and you've nothing to lose in your database, you may as well just restore the cleandata: mysql -u root -p[database-password] plain < [path-to-ezpublish]/kernel/sql/mysql/cleandata.sql Should do it and restore 'publish' as your admin password. Regards, James

Author

Message

Monday 19 January 2004 6:38:48 pm

Have just reinstalled ezPublish 3.2 as i made a mistake in the tutorial provided. Installation completed by ignoring a couple of errors which came up about not being able to edit some dlls. Install completed, but when I try to log into the admin_page with the username admin and pwd publish it doesn't recognise it. I then went into mysql and asked it to show me the databases and tables i had. when i tried to access the table plain, it says "access denied for user @localhost. Any idea's on why this is happening? NOTE: was working the first time I installed, but error started appearing after an uninstall and reinstall.

James Packham

Tuesday 20 January 2004 1:57:26 am

The "user @localhost" bit suggests you didn't enter a username when you ran mysql. You want to enter something like:

mysql -u root -p

This will prompt you for your database password.

Once you're in you should be able to show your databases etc.

Next seeing as its a fresh install and you've nothing to lose in your database, you may as well just restore the cleandata:

mysql -u root -p[database-password] plain < [path-to-ezpublish]/kernel/sql/mysql/cleandata.sql

Should do it and restore 'publish' as your admin password.

Regards,

James

eZ debug

Timing:	Jan 19 2025 04:14:37
Script start
Timing:	Jan 19 2025 04:14:37
Module start 'layout'
Timing:	Jan 19 2025 04:14:37
Module start 'content'
Timing:	Jan 19 2025 04:14:38
Module end 'content'
Timing:	Jan 19 2025 04:14:38
Script end

Main resources:

Total runtime	1.4018 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0062	590.4141	152.6406
Module start 'layout'	0.0062	0.0047	743.0547	39.4766
Module start 'content'	0.0109	1.3889	782.5313	491.4297
Module end 'content'	1.3999	0.0019	1,273.9609	8.1406
Script end	1.4017		1,282.1016

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.2564	16	0.0002
Check MTime	0.0014	0.0969	16	0.0001
Mysql Total
Database connection	0.0012	0.0837	1	0.0012
Mysqli_queries	1.3448	95.9382	54	0.0249
Looping result	0.0007	0.0472	52	0.0000
Template Total	1.3485	96.2	2	0.6742
Template load	0.0020	0.1436	2	0.0010
Template processing	1.3464	96.0546	2	0.6732
Template load and register function	0.0002	0.0171	1	0.0002
states
state_id_array	0.0021	0.1487	1	0.0021
state_identifier_array	0.0030	0.2127	2	0.0015
Override
Cache load	0.0016	0.1170	15	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0010	0.0714	2	0.0005
Fetch class attribute name	0.0016	0.1164	3	0.0005
XML
Image XML parsing	0.0083	0.5933	2	0.0042
class_abstraction
Instantiating content class attribute	0.0000	0.0006	3	0.0000
General
dbfile	0.0084	0.5997	16	0.0005
String conversion	0.0000	0.0006	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 7 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs