Create a database for SMF

Started by mario71, August 18, 2015, 11:49:06 AM

Previous topic - Next topic

mario71

I can not install SMF because I can not create the database could someone send me a clean database with only one user so that the load on my MySQL database .
Thank you


3.Create a database
Now, before you can install SMF, you'll need a database to store all of your forum's information in, and a database user. The database is what stores all of your members, posts, settings and all that kind of stuff. The database user is how SMF will log into the database to get to all that information. From your host control panel, use the database management system to create a database. If your host doesn't automatically create a database user, create one now that has permissions to SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, and INDEX. Make a note of the database URL, database name, user (login) name and password, so you can tell SMF all about it later. If you have any problems doing this, contact your host for help.

Illori

if you dont know how to create the database, contact your host and they can help you create the database.

i would not trust anyone to send you a database as they may include other users or a way they could gain admin access to your forum.

Kindred

besides... even with someone else creating the database -- if you don't have the correct connection information, it won't do you any good.

As Illori says: Contact your host for help with getting the correct connection information to create/access the database.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

mario71

but the error says that gaining access but you have to create the tables

Critical Error !
" Database Sql350995_2 " The Program Install and State Degree of access . SOME With guest , you must create the database in your admin panel before SMF CAN use it . SOME also add prefixes - come the user name - for the names of the database .

Kindred

you need to have a database user which has FULL ACCESS the database -- including CREATE.

Talk to your host on how to set that up.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Deaks

~~~~
Former SMF Project Manager
Former SMF Customizer

Kindred

ah... I also just realized that I misread the error...

you need to CREATE an EMPTY database first....  no tables, no data... just a database.

THEN you can run the installer with the data for the database and database user...   and it will create the tables and necessary data.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

mario71

the problem that I can not create an empty database, someone could send it?
I get this panel and I do not know what to do.
Thank you

Deaks

the issue is we cant send you it as its evident you wouldnt know what to do with it ... can you please provide a translation to what each collumn says
~~~~
Former SMF Project Manager
Former SMF Customizer

Deaks

~~~~
Former SMF Project Manager
Former SMF Customizer

Illori

that looks like phpmyadmin, which looks to be creating a table in an existing database.

as we have said several times, the op has to contact their host if they can not figure out how to create the database.

mario71

I do not understand you use a translator but it is difficult to understand. Thank you all

Deaks

~~~~
Former SMF Project Manager
Former SMF Customizer

JBlaze

mario71, in order to create a database on your server to install SMF, you need to create a database user with the correct permissions. You may want to ask your host for help in doing this as some hosts have custom control panels to do it from.

Once you have created a database, you can then follow the instructions here: Installing SMF
Jason Clemons
Former Team Member 2009 - 2012

shawnb61

I had a similar experience that might help... 

I had attempted to issue a CREATE DATABASE from within myPhpAdmin, just at the SQL prompt.  It appeared to work, but the database was completely inaccessible.   In fact, I still can't do anything with it.   

I found that I had to use the MySql Databases link on cPanel to create the database & user, not myPhpAdmin. 

Everything worked fine after that.  (My host is HostGator.)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Sir Osis of Liver

Quote from: shawnb61 on August 18, 2015, 03:01:48 PM
I found that I had to use the MySql Databases link on cPanel to create the database & user, not myPhpAdmin. 

That's how it works on most hosts.  If OP can't do it himself, there's nothing we can do here to help.
     She is happy where she lies
     With the dust upon her eyes.

mario71

Da non credere!!!!
i dati da me inseriti erano corretti allora....
Il problema sapete quale era?
Ho chiamato il servizio assistenza di Aruba e mi ha risolto il problema,  i dati erano corretti è bastato cancellare i files temporanei di Google Crome con CRTL +H  , poi ho fatto l'installazione aprendo una scheda in incognito e tutto è andato a buon fine.
MA COSE DA PAZZI e chi poteva pensare che il problema era quello!
Grazie a tutti e spero che la mia esperienza serva per far perdere meno tempo ad altri!!!!

Kindred

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

mario71

Do not believe !!!!
Data were entered by myself Fixed Then ....
The Problem Which era do you know?
I called the Service Center in Aruba and he solved the problem, the data were Fixed It sufficed delete temporary files of Google Crome with CTRL + H, then I did the installation OPENING A incognito tab and Everything went well .
MA Crazy things and who could think That the Problem That was!
Thank you all and I hope that my experience will serve for a long time Losing Less ad Other !!!!

Steve

That didn't translate well ...
DO NOT pm me for support!

Advertisement: