# Database access **URL:** \ **Category:** Hosting Support\ **Created:** [December 29, 2021, 4:49am UTC](https://forum.infinityfree.com/t/database-access/56246 "2021-12-29T04:49:06Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 4:49am UTC](https://forum.infinityfree.com/t/database-access/56246/1 "2021-12-29T04:49:06Z")
### Username (e.g. epiz\_XXX) or Website URL [ymvdfhut.epizy.com](http://ymvdfhut.epizy.com) ### Error Message Error: INSERT INTO account (username, password) values (‘dummy’,‘dummy’) Table ‘epiz\_30611799\_test.account’ doesn’t exist If I change the username to just test it tells me I am logged in but user epiz\_30611799 access denied ### Other Information Help ---
**Author:** ![jaikrishna.t](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/jaikrishna.t/32/57109_2.png) [@jaikrishna.t](https://forum.infinityfree.com/u/jaikrishna.t)\ **Post date:** [December 29, 2021, 4:50am UTC](https://forum.infinityfree.com/t/database-access/56246/2 "2021-12-29T04:50:31Z")
Welcome @anon91859408, we’re glad to have you here! Are you sure the database exists? > [@anon91859408](#): > > epiz\_30611799\_test.account Also, you cannot use `dot` in a database name. I sus that was a typo error? I also see that you’re account is suspended, can you check in your client area once? Thanks, lemme know if you need any help! ---
**Author:** ![KangJL](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/kangjl/32/12130_2.png) [@KangJL](https://forum.infinityfree.com/u/KangJL)\ **Post date:** [December 29, 2021, 4:55am UTC](https://forum.infinityfree.com/t/database-access/56246/3 "2021-12-29T04:55:28Z")
> [@anon91859408](#): > > [ymvdfhut.epizy.com](http://ymvdfhut.epizy.com) Are you sure you provided the right info? ![image](https://forum-cdn.infinityfree.net/original/3X/b/1/b113351a9ce1548ad7abb2d15472d7462e076313.png) ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 8:12am UTC](https://forum.infinityfree.com/t/database-access/56246/4 "2021-12-29T08:12:30Z")
My client area shows my account as active. I will check my script again but I have no idea where a dot in my name came from. I copied and paste the database info directly from my control panel. ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 8:17am UTC](https://forum.infinityfree.com/t/database-access/56246/5 "2021-12-29T08:17:02Z")
That is the domain name listed in my control panel the actual domain is www.theguardians.rf.gd I am pretty sure I am entering the right info. ---
**Author:** ![Admin](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/admin/32/36437_2.png) [@Admin](https://forum.infinityfree.com/u/Admin)\ **Post date:** [December 29, 2021, 8:39am UTC](https://forum.infinityfree.com/t/database-access/56246/6 "2021-12-29T08:39:34Z")
> [@anon91859408](#): > > Table ‘epiz\_30611799\_test.account’ doesn’t exist Like the message says: there is no table `account` in that database. If you want to insert data into a table, you need to create it first. ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 8:49am UTC](https://forum.infinityfree.com/t/database-access/56246/7 "2021-12-29T08:49:38Z")
The table shows in my control panel the name is epiz\_30611799\_test with two columns one username with char 20 not null primary and password varchar 40 not null. ---
**Author:** ![Admin](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/admin/32/36437_2.png) [@Admin](https://forum.infinityfree.com/u/Admin)\ **Post date:** [December 29, 2021, 8:56am UTC](https://forum.infinityfree.com/t/database-access/56246/9 "2021-12-29T08:56:33Z")
Where do you see it? I don’t see that table: ![image](https://forum-cdn.infinityfree.net/original/3X/d/c/dc0a62ae438adfdeb198ae9a5293d593d99c92c2.png) There is only a table `test`, not a table `account`. ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 8:57am UTC](https://forum.infinityfree.com/t/database-access/56246/10 "2021-12-29T08:57:32Z")
That is where I created the table ---
**Author:** ![Admin](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/admin/32/36437_2.png) [@Admin](https://forum.infinityfree.com/u/Admin)\ **Post date:** [December 29, 2021, 9:03am UTC](https://forum.infinityfree.com/t/database-access/56246/11 "2021-12-29T09:03:44Z")
What do you mean by that? There is no table `account`. There is only one table, and it’s called `test`. > [@anon91859408](#): > > The table shows in my control panel the name is epiz\_30611799\_test with two columns one username with char 20 not null primary and password varchar 40 not null. That’s not the table name, that’s the database name. And the schema you’re describing is from the table `test`. There is no table `account`, so you can’t `INSERT INTO account` because there is no `account` table to insert stuff into. * * * In the control panel, you can create one or more **databases**. The database names are identified by your account username and a suffix you can choose, e.g. `epiz_12345678_mydb`. Within the database, you can create **tables**. You can give the table pretty much any name you want, like `mytable`. If you want to insert data into a table, you first setup a **connection to the database** and then **insert into the table**. So, using the examples from before, the query would look like: ```auto INSERT INTO mytable (colum1, column2) values ('value1', 'value2') ``` In your account, you have a **database** called epiz\_30611799\_test, with a **table** called `test`. So if you want to insert data into it, you have to create a query like `INSERT INTO test ...`. If you want to create a table `account`, you can do so too, either through our phpMyAdmin or through your PHP code. But right now, you only have a table `test`, not a table `account`. ---
**Author:** ![jaikrishna.t](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/jaikrishna.t/32/57109_2.png) [@jaikrishna.t](https://forum.infinityfree.com/u/jaikrishna.t)\ **Post date:** [December 29, 2021, 10:42am UTC](https://forum.infinityfree.com/t/database-access/56246/13 "2021-12-29T10:42:16Z")
Mods, please hide the password. @Greenreader9 and @Oxy thanks! ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 10:48am UTC](https://forum.infinityfree.com/t/database-access/56246/14 "2021-12-29T10:48:19Z")
deleted post didn’t realize i had not taken out the password thanks ---
**Author:** ![jaikrishna.t](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/jaikrishna.t/32/57109_2.png) [@jaikrishna.t](https://forum.infinityfree.com/u/jaikrishna.t)\ **Post date:** [December 29, 2021, 10:55am UTC](https://forum.infinityfree.com/t/database-access/56246/15 "2021-12-29T10:55:53Z")
It’s still visible, only mods can remove them! ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 11:05am UTC](https://forum.infinityfree.com/t/database-access/56246/16 "2021-12-29T11:05:05Z")
My screen says post withdrawn by author will be automatically deleted in 24 hours unless flagged (whatever that means). Anyway I did figure out what the problem was. Thanks for all your help. Is it possible for me to change my password? ---
**Author:** ![jaikrishna.t](https://forum.infinityfree.com/user_avatar/forum.infinityfree.com/jaikrishna.t/32/57109_2.png) [@jaikrishna.t](https://forum.infinityfree.com/u/jaikrishna.t)\ **Post date:** [December 29, 2021, 11:09am UTC](https://forum.infinityfree.com/t/database-access/56246/17 "2021-12-29T11:09:18Z")
You can do that from your client area! ---
**Author:** ![anon91859408](https://forum.infinityfree.com/letter_avatar/anon91859408/32/5_5575768a8748004e209b776fc1b2916d.png) [@anon91859408](https://forum.infinityfree.com/u/anon91859408)\ **Post date:** [December 29, 2021, 11:20am UTC](https://forum.infinityfree.com/t/database-access/56246/18 "2021-12-29T11:20:55Z")
I found the area thanks for all your help ---
**Author:** ![system](https://infinityfree-forum-uploads.s3.dualstack.eu-central-1.amazonaws.com/original/3X/b/0/b024fd3fa88bae093c9576e55c2c94e33f890206.svg) [@system](https://forum.infinityfree.com/u/system)\ **Post date:** [January 5, 2022, 11:21am UTC](https://forum.infinityfree.com/t/database-access/56246/19 "2022-01-05T11:21:26Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.