MyBB Community Forums

So i have my MySQL database setup on a server. it also has other stuff on it and i let my friend use my database since we just use it for minecraft and other little thing we both run websites but i always used localhost to connect. i know i need to create a roaming user with admin rights so the database can be access from outside the network but don't know how is there a command i need? or is there an button on the MySQL workbench.

---

Fixed it just followed theses steps on
http://dev.mysql.com/doc/refman/5.1/en/a...users.html

and changed a setting i had that only allowed local connections

I think you need make user table?

example code:

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- mysql: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `u_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_username` varchar(40) NOT NULL,
  `u_password` varchar(32) NOT NULL,
  `u_email` varchar(50) NOT NULL,
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- delete data table `users`
--

INSERT INTO `users` (`u_id`, `u_username`, `u_password`, `u_email`) VALUES
(1, 'kamran', '0cc175b9c0f1b6a831c399e269772661');