Search Articles

Advanced search

Interspire Product Knowledge Base

Would you like to...

Print this page Print this page

Email this page Email this page

Post a comment Post a comment

Subscribe me

Add to favorites Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Export to PDF

User Opinions (2 votes)

50% thumbs up 50% thumbs down

How would you rate this answer?



Thank you for rating this answer.

How do I create a new user in a Jumpline MySQL account via ssh?

To set up a new MySQL user into your Jumpline account you will need to ssh into your server and run the following commands.

/etc/rc.d/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql> mysql
mysql> use mysql;
mysql> delete from user where user='username' and host='localhost';
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO user VALUES('localhost','username',PASSWORD('password'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
Query OK, 1 row affected, 5 warnings (0.00 sec)
FLUSH PRIVILEGES;
quit

/etc/rc.d/init.d/mysqld stop
/etc/rc.d/init.d/mysqld start

Related Articles

No related articles were found.

Attachments

No attachments were found.

Powered by Interspire Knowledge Manager - World's #1 Best Selling FAQ and Knowledge Base Software