Still cannot connect to database

Previous topic

Install & configuration

Next topic

Author	Message
rick shepherd	Wednesday 29 September 2004 12:14:38 am OK, now I have created a new database: mysql> create database ezno; and a new user mysql> grant all privileges on ezno.* to 'ezno'@'localhost' identified by 'ezno'; I then fill in the values: Servername: ezno Username: ezno Password: ezno Socket (optional): (blank) and I still get The database would not accept the connection, please review your settings and try again. Any ideas??
Tobias Persson	Wednesday 29 September 2004 12:37:28 am I think Servername might be wrong. Normally (if you run the database on the same server as the webserver) it should be Localhost
Frederik Holljen	Wednesday 29 September 2004 1:46:01 am servername is the internet address of the server where your sql server is located. If it's the same machine use "localhost". If not use either the full name of the server (e.g: myserver.mydomain.co.uk) or the ip address.

Author

Message

rick shepherd

Wednesday 29 September 2004 12:14:38 am

OK, now I have created a new database:

mysql> create database ezno;

and a new user

mysql> grant all privileges on ezno.* to 'ezno'@'localhost' identified by 'ezno';

I then fill in the values:

Servername: ezno
Username: ezno
Password: ezno
Socket (optional): (blank)

and I still get

The database would not accept the connection, please review your settings and try again.

Any ideas??

Tobias Persson

Wednesday 29 September 2004 12:37:28 am

I think Servername might be wrong.

Normally (if you run the database on the same server as the webserver) it should be Localhost

Frederik Holljen

Wednesday 29 September 2004 1:46:01 am

servername is the internet address of the server where your sql server is located. If it's the same machine use "localhost". If not use either the full name of the server (e.g: myserver.mydomain.co.uk) or the ip address.

eZ debug

Timing:	Jan 19 2025 08:52:01
Script start
Timing:	Jan 19 2025 08:52:01
Module start 'layout'
Timing:	Jan 19 2025 08:52:01
Module start 'content'
Timing:	Jan 19 2025 08:52:01
Module end 'content'
Timing:	Jan 19 2025 08:52:01
Script end

Main resources:

Total runtime	0.0181 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0060	589.2891	152.6406
Module start 'layout'	0.0060	0.0038	741.9297	39.4766
Module start 'content'	0.0098	0.0059	781.4063	89.3672
Module end 'content'	0.0158	0.0023	870.7734	30.3047
Script end	0.0180		901.0781

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	13.8396	14	0.0002
Check MTime	0.0011	6.2611	14	0.0001
Mysql Total
Database connection	0.0011	6.2229	1	0.0011
Mysqli_queries	0.0029	16.0946	3	0.0010
Looping result	0.0000	0.2215	1	0.0000
Template Total	0.0018	10.2	1	0.0018
Template load	0.0010	5.4976	1	0.0010
Template processing	0.0008	4.6629	1	0.0008
Override
Cache load	0.0006	3.2848	1	0.0006
General
dbfile	0.0003	1.5481	8	0.0000
String conversion	0.0000	0.0514	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs