Raised This Month: $91 Target: $400
 22% 

Vault to MySQL Saving Via Windows Steps.


Post New Thread Closed Thread   
 
Thread Tools Display Modes
CounterCraft
Junior Member
Join Date: Feb 2008
Old 04-13-2008 , 11:49   Re: Vault to MySQL Saving Via Windows Steps.
#41

Quote:
Originally Posted by yang View Post

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 [email protected];

    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 [email protected] 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 [email protected] IDENTIFIED BY 'password';

and paste it instead of the old one:

CREATE DATABASE IF NOT EXISTS SHeroDB;
USE SHeroDB;
GRANT SELECT ON `SHeroDB`.* TO [email protected];

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.
CounterCraft is offline
Alexel
Junior Member
Join Date: Mar 2008
Old 04-22-2008 , 08:06   Re: Vault to MySQL Saving Via Windows Steps.
#42

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!

TXT yang!
Alexel is offline
Pewor
New Member
Join Date: Jun 2008
Old 06-19-2008 , 08:22   Re: Vault to MySQL Saving Via Windows Steps.
#43

where can i find the sql file?
Pewor is offline
Enipy
BANNED
Join Date: Jan 2009
Old 09-05-2009 , 11:36   Re: Vault to MySQL Saving Via Windows Steps.
#44

The link of shero_mysql_install.sql

It not found, pliz new link?
Enipy is offline
Send a message via MSN to Enipy
matan7890
Junior Member
Join Date: Aug 2009
Old 03-06-2010 , 15:18   Re: Vault to MySQL Saving Via Windows Steps.
#45

Quote:
Originally Posted by Pewor View Post
where can i find the sql file?
Quote:
Originally Posted by Enipy View Post
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 ...




Quote:
Originally Posted by Alexel View Post
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!

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 )
__________________
sorry for the bad english...
matan7890 is offline
alconnegro
Member
Join Date: Jun 2010
Old 08-23-2010 , 22:21   Re: Vault to MySQL Saving Via Windows Steps.
#46

2 link is not working, someone has the files?
__________________
[IMG]http://img718.**************/img718/7375/wtfzv.jpg[/IMG]
alconnegro is offline
Jelle
[b]MOAR CANDY[/b]
Join Date: Aug 2009
Location: Denmark
Old 08-23-2010 , 22:43   Re: Vault to MySQL Saving Via Windows Steps.
#47

https://forums.alliedmods.net/showthread.php?t=76081
__________________
No idea what to write here...
Jelle is offline
Send a message via MSN to Jelle
Closed Thread


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 00:16.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode