Pleaze help

Hosting Support
1

Username (e.g. epiz_XXX) or Website URL

sklmr.ml, but does that matter?

Error Message

Error

SQL query:

CREATE DATABASE `twitter` /*!40100 DEFAULT CHARACTER SET utf8mb4 */

MySQL said:
#1044 - Access denied for user 'epiz_30479882'@'192.168.%' to database 'twitter'

Other Information

tryna test bwitter and skid, but mind weak and tells no. What do i do? (m too new at sql)

3

bwitter.me
its what im trying to test

4

Localhost IP?
Check your database credentials again and make sure it matches the one shown in client area.

5 
CREATE DATABASE `twitter` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `twitter`;

CREATE TABLE `data` (
  `name` text NOT NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `data` (name,value) VALUES
     ('notice','');

CREATE TABLE `reports` (
  `id` int(11) NOT NULL,
  `bweet` int(11) NOT NULL,
  `reporter` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `timezones` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `tweets` (
  `id` bigint(20) NOT NULL,
  `content` text NOT NULL,
  `user` text NOT NULL,
  `timestamp` int(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `users` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `fullname` text NOT NULL,
  `email` text NOT NULL,
  `username` text NOT NULL,
  `timezone` text NOT NULL,
  `password` varchar(255) NOT NULL,
  `flags` int(11) NOT NULL DEFAULT 1,
  `data` text NOT NULL DEFAULT '{}',
  `bio` text NOT NULL DEFAULT '',
  `location` text NOT NULL DEFAULT '',
  `web` text NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

what do i change?
xd

6

Where is this code going? In a PHP file?

7

Database names are always prefixed with your account username. So if you created a database with name twitter, the actual database name will be epiz_30479882_twitter.

1 Like
8

sql.
i try to imp[rt that, i fael

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.