RadioDJ tutorials

      What is HeidiSQL?

      HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers
      using the popular MySQL-Database or MariaDB-database.
      It allows you to manage and browse your databases and tables from an intuitive Windows interface.

      With HeidiSQL you will also be able to.

        • Manage Microsoft SQL Servers, with a reduced feature set.
        • Generate nice SQL-exports.
        • Synchronize tables between two databases.
        • Manage user-privileges.
        • Import text-files.
        • Export grid-data as CSV, HTML, XML, SQL, LaTeX, Wiki and PHP Array style.
        • Browse and edit table-data using a comfortable grid.
        • Create and edit tables, views, stored routines, triggers and scheduled events.
        • Bulk edit tables (move to db, change engine, collation etc.).
        • Batch-insert ascii or binary files into tables.
        • Write queries with customizable syntax-highlighting and code-completion.
        • Profile your queries.
        • Pretty reformat disordered SQL.
        • Monitor and kill client-processes.
        • Connect to servers via commandline.
        • Find specific text in all tables of all databases of one server.
        • Optimize and repair tables in a batch manner.
      And much more.

HeidiSQL sqlserver manager.

At startup you get the login screen.
Enter the password that you specified installing the sqlserver.
Click on Open.

The screen with the tables that RadioDJ has made are now visible.

Create a new user.
To create an new user, click on Tools and select User Manager.

In the popup screen click on Add.

Put in a new user name.
On From Host, choose Access from anywhere (% will show up.
Put in a password and repeat it.
Select In the Allow access to:

Click on Save.

Select the just made new user:

Click on Clone.
Fill in the new user name as bifor and the passwords but set From Host: on localhost.
Click on Save and Click on Close.

Back to top
©  JWL  2013 | 2018