MySQL with 000webhost

Discuss
#1

Hi everyone, I’m trying to connect a MySQL database to my App using 000webhost.
However, I am only receiving “Bad Request”.

I configured the script as described in the link. However, I have no return from the bank.
It’s currently just testing, so:

My blocks:

Summary

image
image1015×303 40 KB

image
image

My 000webhost db:

Summary

image
image

From what I read in the community, it seems I can’t use special characters in the password, is that right?
If yes, how can I add a password without special characters using 000webhost? I couldn’t when I tried!

Thanks!

#2

Did You try with http instead HTTPS ?
Did You clear browser cache ?
Did You check your URL ?

#3

Yes, I tested it with “http” and “https”.
About the cache, yes, and nothing has changed.
When I use an anderline “_” in the password, I get this:

Summary

image
image825×228 52 KB

1 Like
#4

Why not use the sql extension

#5

Well, from what I’ve read, deep host extensions aren’t really recommended. However, I believe the result is the same, am I right?

#6

User privileges.
User without access privileges

#7
1 Like
#8

I’m using 000webhost. I didn’t see how to register a new user or change permissions. Could you guide me through this process? Just give me a hint on the way!

#9

Generally, in the host’s control panel (in your case, 000webhost ) there is the database maintenance area.
Check if this user has access and if his password is the same one you set in the PHP script.

#10

If I failed to use this method, I will follow the video. Thank you very much!

#11

You will not fail.
You don’t need this Extension.
In addition to this script there is another one by Juan
But the error that is occurring is not caused by the script
OK ?

1 Like
#12

The menu is extremely limited. Even in phpmyadmin, I don’t see options to register or change privileges.

Summary

image
image694×314 14.9 KB

image
image1530×453 62.4 KB

#13

Well I don’t have 000webhost. I use hostinger and as I said, you must configure privileges.

2 Likes
#14

https://www.000webhost.com/forum/t/how-to-connect-to-database-using-php/42093

1 Like
#15

The directory:

Summary

image
image1387×180 8.75 KB

That’s what I thought. I didn’t notice anything wrong either in the script or in the other settings. It worked without problems on another bank when I tested it.
I will test on another hosting!!

Sorry for not following the video you recommended @_FTTX. Is that using the blocks I mentioned, the whole process becomes simpler by using simple SQL commands.

Thanks @Rogerio_Rios

1 Like
#16

In same 000webhost ?

#17

No, sorry. It was with local testing. :+1:

#18

https://www.topbestalternatives.com/000webhost/

#19

Did You check passwords , the database and host access password?

#20

It was on that page right now @Rogerio_Rios!
I’ll run some tests.
Thanks!

Yes, the password is the same.

1 Like