RESOLVE - Need some help with ttransaction
lazarus / 16-Databases

----------------------------------------------------------------------
Marie · 2011-06-14 20:05

Hello,

I'm new user with lazarus and I want to connect with a mysql database.

In a new form i put tmysql50connexion
Host name 127.0.0.1
Username root
databaseName general (it's the name of my database)

and when i arrive to change connected to true
i have de error message :"MySql50Connection1 :failed to select
database: Undnown database 'general'

but if i place DatabaseName: Mysql
all is ok

I think possibly alias or permission is missing

I hope you understand my message because english is not my language.

Thanks,
Marie

----------------------------------------------------------------------
Loesje · 2011-06-14 20:29

Check the name of the database. Maybe it's case sensitive, like
'General'? Or the root-user doesn't have rights to the database?

----------------------------------------------------------------------
RobyWan · 2011-06-14 22:11

Silly observation:
1) is mysql services active?
2) is the database in the correct place (don't you have copied in
another directory after the creation)?
3) check with xampp (or other) the name of the database

Greetings!

----------------------------------------------------------------------
RudieD · 2011-06-14 22:36

To check the database exists :
From a terminal session (bash) type
Code: [Select]mysql -uroot -pAfter you hit enter type in the password
for the mysql root user.

In mysql type
Code: [Select]show databases; and enter.
It will list all your databases on your local PC.

To quit, just type
Code: [Select]quit and Enter
then
Code: [Select]exit and Enter.

Hope this helps.

----------------------------------------------------------------------
Marie · 2011-06-15 03:45

Quote from: Loesje on June 14, 2011, 10:29:55 pmCheck the name of the
database. Maybe it's case sensitive, like 'General'? Or the root-user
doesn't have rights to the database?

the database is really general in lower cap
but how i can verify the root-user rights to the database and if is
not create it

Thanks

----------------------------------------------------------------------
Marie · 2011-06-15 03:49

Quote from: RobyWan on June 15, 2011, 12:11:23 amSilly observation:
1) is mysql services active?
2) is the database in the correct place (don't you have copied in
another directory after the creation)?
3) check with xampp (or other) the name of the database

Greetings!

1- mysql is active because i can access the mysql database
2-no it is at initial place of installation
3- I utilized wampserver for verify the name of the database and it's
ok

Thanks

----------------------------------------------------------------------
Marie · 2011-06-15 03:50

Quote from: RudieD on June 15, 2011, 12:36:15 amTo check the database
exists :
From a terminal session (bash) type
Code: [Select]mysql -uroot -pAfter you hit enter type in the password
for the mysql root user.

In mysql type
Code: [Select]show databases; and enter.
It will list all your databases on your local PC.

To quit, just type
Code: [Select]quit and Enter
then
Code: [Select]exit and Enter.

Hope this helps.

I'm with windows vista and i make this test with wampsserver and the
database is present