AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Tech Support (https://forums.alliedmods.net/forumdisplay.php?f=36)
-   -   Vault to MySQL Saving Via Windows Steps. (https://forums.alliedmods.net/showthread.php?t=35432)

CounterCraft 04-13-2008 10:49

Re: Vault to MySQL Saving Via Windows Steps.
 
Quote:

Originally Posted by yang (Post 302565)

4, Open it with a text editor program.
  • Notice this part of the code:

    CREATE DATABASE IF NOT EXISTS SHeroDB;
    USE SHeroDB;
    GRANT SELECT ON `SHeroDB`.* TO SuperHeroModUser@localhost;

    Here "SHeroDB" is the database name.
    The user is SuperHeroModUser Restricted to: localhost

    I prefer to have a password on it. So I switched it to:

    GRANT SELECT ON `SHeroDB`.* TO SuperHeroModUser@localhost IDENTIFIED BY 'password';

    Close & Save.
5, Put it into C: drive.

6, Open DOS Command ( Start -> Run -> type "cmd" )

7, Go into your mysql/bin folder

8, Type "mysql -uroot -ppassword < C:\shero.sql"
  • This will automatically create a superhero database for you.

what should i do? should i copy
GRANT SELECT ON `SHeroDB`.* TO SuperHeroModUser@localhost IDENTIFIED BY 'password';

and paste it instead of the old one:

CREATE DATABASE IF NOT EXISTS SHeroDB;
USE SHeroDB;
GRANT SELECT ON `SHeroDB`.* TO SuperHeroModUser@localhost;

Then when i write mysql -uroot -ppassword < C:\shero.sql
i get this error:
ERROR 1045 <28000>: access denied for user 'root'@'localhost' <using password YES>


i haven't selected a password, i just copied it and pasted it instead of the old one.

Alexel 04-22-2008 07:06

Re: Vault to MySQL Saving Via Windows Steps.
 
I finded why my xp on mysql database not saving good the xp...
Because my server is non-steam....but i make a new server steam only!:mrgreen:

TXT yang!

Pewor 06-19-2008 07:22

Re: Vault to MySQL Saving Via Windows Steps.
 
where can i find the sql file?

Enipy 09-05-2009 10:36

Re: Vault to MySQL Saving Via Windows Steps.
 
The link of shero_mysql_install.sql

It not found, pliz new link?

matan7890 03-06-2010 14:18

Re: Vault to MySQL Saving Via Windows Steps.
 
Quote:

Originally Posted by Pewor (Post 640898)
where can i find the sql file?

Quote:

Originally Posted by Enipy (Post 923739)
The link of shero_mysql_install.sql

for you and for all the others, here is the link (after a little search...)
http://forums.alliedmods.net/attachm...2&d=1153952938
In this there is the file and other files...
The other files are from the old version so dont use them :shock::o:nono::mrgreen:...




Quote:

Originally Posted by Alexel (Post 615024)
I finded why my xp on mysql database not saving good the xp...



Because my server is non-steam....but i make a new server steam only!:mrgreen:

TXT yang!

I'm using non-steam server to and its working perfect!
Are you sure that u install that corectly?
Send me pm... (or if you realy want write here :wink:)

alconnegro 08-23-2010 21:21

Re: Vault to MySQL Saving Via Windows Steps.
 
2 link is not working, someone has the files?

Jelle 08-23-2010 21:43

Re: Vault to MySQL Saving Via Windows Steps.
 
https://forums.alliedmods.net/showthread.php?t=76081


All times are GMT -4. The time now is 18:56.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.